Posts
Sort by recent activity
Unsupported Folder
After resolving the items in this folder, is it safe to remove the folder from the project?https://documentation.red-gate.com/sca/developing-databases/concepts/baseline/resolving-unsupported-progra...
Add to project but do not deploy?
I had someone add a slew of objects (Stored procs, views, users, roles, tables) to a production DB outside of my normal deployment with SCA.What is the best way to go about getting them into my pro...
UseCreateOrAlterForRerunnableScripts
Recent release notes indicate this was added. Where is this set? I assume in the sqlproj file? What is the syntax? IS there any doco around this?Thanks
Extension wording when running scripts
I believe this applies to both VS and SSMS extensions, when you let it to check for new changes it puts up a message while it does its thing saying: "Checking [Server\Instance].[DbName] for changes...
Issues with SSMS add-in
1. Updating the SSMS add-in yesterday removed the extension from VS 2019. I had to reinstall it.2. After generating schema scripts and clicking done. It spins for a bit and produces the following e...
Dealing with passwords in SCA projects
What is the recommended method for handling passwords in SCA projects? For creating users or adding credentials for a linked server, etc. I am using azure devops server and I see that I can use sec...
Visual studio extension thinks a trigger has changed when it did not
Version: 3.0.19052.5318Shows a table with pending changes. Change summary: Alter trigger. No changes have been made to this trigger. When I right click and view object differences there are no chan...
Quick PowerShell hack to view IncludeObjectsInDataSync
We have a need to view which tables are set to include data and the current UI is awful for finding this in visual studio. I opened a user voice for this but until this is implemented, here is a q...
Where is the table data in XML format kept?
I seem to have run into an issue where old static data must be cached some place. I have a table where I just selected "Include table data" it wants to make a script to insert 9 rows (without the i...
Programmable Objects and extended property
Making a change to the extended property of a Programmable Object makes SCA drop and recreate the object. Can this be avoided? This changes with creation and modification dates. When the only chang...