Articles
Sort by recent activity
Sign commits with an SSH key
If Git is configured to use commit signing with an SSH key, you won’t be able to commit through Flyway Desktop’s Version Control tab, the icon will simply continue spinning.This happens because Fly...
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...
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...
SQL Source Control is running too slow
SSMS is a 32-bit application and as a result it can only access a maximum of 2GB RAM even if the system it's running on is 64-bit. This memory limit can result in slow performance when working with...
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...
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...
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 ...
Silent Install Clone Agent
This article explains how to download the SQL Clone Agent service silently over the network.
You can use the following PowerShell commands, configured as necessary to achieve this:$username = "<use...
Changing the default location of SQL Clone files
Clone data files are created in the default data location for the SQL Server instance on which they are created. You can change this in SSMS.
Alternatively, it is possible to change the data locati...
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...