Set development source... link does not actually set development source

• 
  Hi @sstewart
  
  Sorry you're getting this issue!
  
  I'm not sure how it gets into this state, but it's fairly common and really easy to fix, if you navigate to your SQL Change Automation project folder and locate a file with your project name and the extension ".sqlproj.user" if you open and edit this file to remove the two properties:
  
  <TargetDatabase>
  <TargetConnectionString>
  
  Save and reload the project in SSMS then set the development source again and this should resolve the error!
  
  
  
  

  DanC June 01, 2022 16:01

  - 0 +
• 
  I'm getting the same issue version 4.4.22207.31111
  
  The ".sqlproj.user" file doesn't contain either of these properties.

  WillC August 02, 2022 07:57

  - 0 +
• 
  Hi @WillC
  
  In that case, could you try deleting the file and close and reopen the project, otherwise, open the .sqlproj.user file and edit to add the following 
   
  "<ShadowConnectionString>Data Source=YourServer;Initial Catalog=YourShadowDB_shadow;Integrated Security=True</ShadowConnectionString>"
   
  For example it could look like this:
   
  
   
  

  Kind regards

  DanC August 02, 2022 08:27

  - 0 +
• 
  Thanks, deleting the entire file sorted it. I fear I will come back to this in a few months and get the same issue and forget this fix.
  
  Is there anything you need from me or I can do to help your dev team diagnose the issue to help get a more permanent fix for this?

  WillC August 02, 2022 08:44

  - 0 +
• 
  Hi @WillC
  
  It's quite an uncommon issue and we're not sure why this occurs, but it's relatively easy to fix on the plus side

  DanC August 02, 2022 08:46

  - 0 +

Add comment

Please sign in to leave a comment.