Articles
Sort by recent activity
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...
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...
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 ...
That folder isn't in a Git repository error
You will get this message when you choose Git when attempting to link your database to a Version Control System and link it to a folder that isn't a git repository.
To avoid this error message you ...
Why we don't recommend using Shared Mode with Git
We don't recommend using Shared mode with Git; here's an example of why:
Our database development team is Alix and Bob.
Alix and Bob develop against a single, shared database. They use SQL Source ...
The 'SqlSourceControlPackage' package did not load correctly
This issue can have multiple causes:
Using an outdated SQL Source Control version
SOC is compatible with the versions of SSMS available at the time of its release.
It is good practice to always mak...