Replay doesn't work with Azure SQL

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud

MIT License

234 stars 53 forks source link

Replay doesn't work with Azure SQL #60

Closed noamo48 closed 4 years ago

noamo48 commented 5 years ago

I tested SqlWorkload against a standard Azure SQL database today and found something weird. None of the commands replayed because it kept giving the error that "USE" statements are not allowed in Azure SQL. When I filtered through the events in the SQLite replay db, none of them actually contained a "USE" statement.

Is SqlWorkload inserting the "USE" statement? If so, it is a bug.

spaghettidba commented 5 years ago

I'll look into it, thanks

spaghettidba commented 4 years ago

Can't reproduce