Not able to set data source in SQL Management Studio

Hi,
Currently I am not able to set my database that is required to be updated in SQL Server Management studio with the SCA plugin. For me it is a blocker at the moment since there is no support for VS2022.
Regards,
David.
Currently I am not able to set my database that is required to be updated in SQL Server Management studio with the SCA plugin. For me it is a blocker at the moment since there is no support for VS2022.
Regards,
David.
Tagged:
Best Answer
-
DanC Posts: 455 Gold 3
Hi @DavidVer
I'm going to reach out via a support ticket as in this case I think it would be good to get the log files!Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
Sorry to hear you're experiencing this issue!
Could you try removing the "<TargetDatabase>" and "<TargetConnectionString>" from the ".sqlproj.user" file, then open the project from SSMS and this will allow you to select a development database.
Let me know if this helps!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
These are the only lines in my .sqlproj.user file at the moment.
Interesting, thanks for that update.
When you open the project in SSMS, are you prompted to set the development source?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Yes I am prompted for setting a data source. Attached are some screenshots from my local SMSS and SCA.
After testing the DB connection OK and clicking on OK I still have the "No Development Source" showing.
Sorry to hear you're experiencing this issue also!
Can I check, have you tried clearing out all the values in the .sqlproj.user file and then remapping the connection details?
In the support ticket behind the scenes, David manually added the target into the file and that worked, could you try the same potentially?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Ah, sorry you had to go through that level of hassle!
I'm pleased to hear it's now working well for you now.
If you come across anything else don't hesitate to reach out to us on support
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?