search

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 commands impersonating the original login #53

Open spaghettidba opened 5 years ago

spaghettidba commented 5 years ago

It might be useful to add the ability to replay the workload by impersonating the original login. This can be done in some ways:

  1. Create a login mapping file, containing username/passwords for sql logins to use on the target server for each source login (and a default when nothing is matched)
  2. Use EXECUTE AS LOGIN (needs to be investigated, has some limitations)

A parameter could control the behavior.