How can we help you today? How can we help you today?

How do I customize the name of the shadow database by including the user's credentials?

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.
Ian Mackenzie
0

Comments

3 comments

Sort by
  • David Atkinson
    Try adding this to your .user file. This should work for any Windows environment variable.
    &nbsp; &nbsp;<ShadowConnectionString>Data&nbsp;Source=SERVER\INSTANCE;Initial&nbsp;Catalog=ProjectName_$(username)_shadow;Integrated&nbsp;Security=True</ShadowConnectionString>
    David Atkinson
    0
  • BIDev
    Outstanding... thank you!
    BIDev
    0
  • David Atkinson
    No problem We should have documented this better. I've changed the main example in the documentation page to show the $(username) environment variable in use. Thanks for highlighting it.
    David Atkinson
    0

Add comment

Please sign in to leave a comment.