Articles
Sort by recent activity
Azure DevOps self-hosted Flyway pipeline worked example SQL Server
This article is intended to help you get up and running with a pipeline in Azure DevOps for building and deploying your databases using Flyway.
If you would prefer to watch a video, please see my c...
The process cannot access the file 'C:\Users\*******\AppData\Local\Red Gate\SQL Source Control 7\Caches
This error message from SQL Source Control usually occurs due to an anti-virus or similar software locking the file in a process such as scanning.
We recommend adding the SQL Source Control folders...
Duplicate definition troubleshooting in SQL Source Control
You get the error "A duplicate definition was found for the table..."
The duplicate error is usually caused by unnecessary files in your repository which have resulted in duplicate CREATE statement...
Couldn't connect to the database specified by the Target parameter: A connection was successfully established with the server, but then an error occurred during the login process
[error] Couldn't connect to the database specified by the Target parameter: A connection was successfully established with the server, but then an error occurred during the login process. (provider...
What resources are required for involved machines using SQL Clone
The potential machines involved when using SQL Clone are:
Machine hosting clone databases: runs SQL Server and Clone Agent, executes queries, and has SQL Server caches. Stores clone differencing ...
Where is the log out button in SQL Clone?
There is no log out button in SQL Clone.
SQL Clone uses Windows authentication and this method of authentication doesn't really have the concept of "logging out" in the application, since it's just...
Only one Rule Controller can be present if the SIMPLELOGINSUB is used
When you encounter this error, it's because you can't use a masking set that has multiple rule controllers with SQL Clone's imaging workflow currently. This is documented here.
The workaround is n...
Last Changed By column shows Unknown
The Last Changed By column shows the last user to alter an object.
SQL Source Control gets the Last Changed By information from the default trace, and will store the details in tempdb by default.
I...
Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim
You may get deadlock exception when running a substitution rule.
This could be because you have more than one rule in a rule block running against the same table. More about ensuring you set up ap...
SQL Clone Download URLs
If you need to download the SQL Clone PowerShell cmdlets installer or SQL Clone agent installer, the URLs to obtain the installers can be found below.
SQL Clone 2
PowerShell cmdlets installer: /api...