How is SQL Change Automation helping you? Share to win DevOps books.
How does "Always use default connection string for Shadow database" work?
I want to ensure that my shadow database does NOT get created on target servers (esp QA and above). I see the "Always use default connection for Shadow database" and the ability to set the default connection string in the Debug tab of the project properties. Help me understand how to effectively use these two settings. How do I set the default connection string to a DB (e.g. <DBName>_Shadow) that may or may not exist? I can't manually edit the connection string - have to point to an existing DB. Do you recommend creating an empty shadow DB, pointing to it and setting it to be the default?
0 · Share on Twitter