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:
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: