Posts
Sort by recent activity
SQL Change Automation adding permission assignments in the view script and creating schema for role
The project includes a filter that excludes users, roles and security policies. But the baseline script is including object permission assignments to users and roles. I edited the baseline (note th...
baseline includes permission statements with all users and roles excluded
The project Filter is set to exclude all users and roles, (unchecked User and Role and Security Policy items' check boxes in the Filter list). SQL Compare 14 was used to create the filter. Role, Us...
Is there anyway to ignore code that references linked servers?
Is there an option to ignore linked server errors on the project server. I have objects that reference a linked server from code but will never add new code that uses the linked server, so I don't ...
SQL Change Automation - error during release
Wondering if the cause of the error, below, is explainable with the information provided (below) or if the cause is already known:error = "RedGate.SQLCompare.Engine.Registration.ReadFromSnapshot.U...
consider adding feedback to the sql change automation '<-] Import and generate scripts' link
Also, I have a very minor request - in the next update/release please consider adding an distinguishable background color behind the "<-]Import and generate scripts" hyperlink/button to give develo...
SQL Change Automation not showing up in SSMS 2014 and not working in SSMS v 18.3
=======================================UPDATE===========================================This issue was resolved by uninstalled SSMS v. 18.3 and installing v 18.2 instead.===========================...
How are TFS build/release SQL Change Automation shell scripts updated?
We want to upgrade to the new SQL Change Automation 4.0 so that our DBAs can create SCA projects without the requirement for VS. We installed the shell scripts on the TFS server about 1 year ago. I...
Excluding objects from the changes list - how to keep unchecked object scripts unchecked
We have a couple of SCA packages and have unchecked the import check boxes to exclude the roles and users from generating/importing scripts. In one project the unchecked roles and users continue to...
why is my release executing the baseline file?
Project : Development DB is in an advanced state over the Target DB. The baseline is created as the existing target. But the release keeps attempting to execute the baseline file. The migrationLog ...