How do I customize the name of the shadow database by including the user's credentials?
![BIDev](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
I would like to customize the shadow DB configuration, and have used the <project_name>.sqlproj.user file to do so. But since multiple developers might be using the tool and working in the same database, I would like to include the developers username in the name of the shadow database, like "ProjectName_imackenzie_shadow". This is consistent with the default naming convention.
Tagged:
Best Answer
-
David Atkinson Posts: 1,462 Rose Gold 2
Try adding this to your .user file. This should work for any Windows environment variable. <ShadowConnectionString>Data Source=SERVER\INSTANCE;Initial Catalog=ProjectName_$(username)_shadow;Integrated Security=True</ShadowConnectionString>
David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software