Allow Find and Replace in Connection String

It is possible to perform find and replace in Connection String at runtime by enabling “Allow Find and Replace In Connection String”.

The “Find and Replace (Pattern=Replacement)” TextBox can be used to specify the pattern and replacement to be used.

For example if you have the following find and replace pattern in General Settings: 'ServerName=SQLWorkshops\SQL2014'

and enable “Allow Find and Replace In Connection String”, the pattern 'ServerName' in connection string will be replaced with 'SQLWorkshops\SQL2014' at runtime. And when you start a workload with the following SQL Command:

select @@servername

the results tab will show SQLWorkshops\SQL2014 as select @@servername.

It is also possible to provide different find and replace patterns for different threads using Server Driven Workload feature.

Please help us improve this page by entering your comments and suggestions below:

  • Captcha image