Articles
Sort by recent activity
Meanings of the colored dots in the SSMS Object Explorer for SQL Source Control
In the object explorer of SQL Server Management Studio (SSMS) SQL Source Control uses colored dots to indicate several different status types for the status of SQL Source Control or the type of cha...
Unable to resolve package source
You get the following error message when running a SQL Change Automation Powershell:
Unable to resolve package source 'https://www.powershellgallery.com/api/v2'.No match was found for the specified...
How to Link SQL Source Control to TFS
Git in TFS/VSTS
If you're using TFS/VSTS with Git-based version control, you can't use TFS mode to link. Instead, you need to link in Git mode.
In the Object Explorer, select the databas...
error 5(Access is denied.) while attempting to open or create the physical file
This error can occur when using SQL Change Automation Powershell, with the default option of validating the schema folder in LocalDB, and you have LocalDB 2017 installed.
This is caused by a bug i...
How to link to an existing SVN repository
Linking to SVN
After you link
Linking to SVN
To do this, you will need to be able to link to the folder where the RedGate.ssc file is located.
In the Object Explorer, select the database you wan...
SQL Change Automation Installation freezes at 99%
If you find that your SQL Change Automation installation freezes at 99% try installing the extension using the Visual Studio Marketplace (SQL Change Automation Core) before running the installer: h...
SQL Change Automation Powershell permissions
When working with SQL Source Control Projects, SQL Change Automation PowerShell requires the same permissions as SQL Compare:
Permissions required to use SQL CompareBuild step specific:
Besides the...
Objects changed by unknown
The Changed by column in the Commit Tab might list objects as changed by Unknown.
Please see the following documentation for troubleshooting steps and workarounds:
Object changed by Unknown
Sequence contains more than one matching element
The error message "Sequence contains more than one matching element" when opening SQL Multi Script can usually be worked around by recreating the Application.dat file.
1. Make sure SQL Multi Script...
Server Aliases not working when connecting with SQL Compare/SQL Data Compare
When you try to connect to an instance using a server alias, you get the error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
and you ...