Comments
24 comments
-
This is awesome!
Gave is a try, having issue with stored proc referencing custom data type:This worked with sql compare 12 windows same setup. Where issues can be reported for sql compare docker 14?Column, parameter, or variable #1: Cannot find data type
-
Hi everyone,
To find out more about SQL Compare 14, check out this product learning article.
Cheers,
Roseanna -
This looks very helpful, especially for non-Windows based build systems. When I try to run the CLI based on the scripts, it fails to connect my local SQL Server - do we need to set up networking to allow the CLI access? There's no indication of it in the examples.
My script is:<div>docker run --rm --interactive --tty \ --mount type=bind,source=/src/scripts,target=/src \ redgate/sqlcompare \ /IAgreeToTheEULA \ /Scripts1:/src \ /Server2:localhost /Database2:MyDatabase /UserName2:Deployments /Password:my-secret-password </div>
which results in the error message:SQL Compare V14.7.2.20940 ==================================================================================================================================================================== Copyright © Red Gate Software Ltd 1999-2022 Beta (expires on Wednesday, 06 July 2022) Warning: Some settings are missing from the RedGateDatabaseInfo.xml file in the scripts folder '/src': default values will be used for any omitted setting. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify<br>that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)
-
Oops, never mind; I think the password was wrong!
#FacePalm -
wow, it looks rpomising,I am gonna give it a try and update you guys here . Thanks.David_Keaveny said:This looks very helpful, especially for non-Windows based build systems. When I try to run the CLI based on the scripts, it fails to connect my local SQL Server - do we need to set up networking to allow the CLI access? There's no indication of it in the examples.
My script is:
<div>docker run --rm --interactive --tty \ --mount type=bind,source=/src/scripts,target=/src \ redgate/sqlcompare \ /IAgreeToTheEULA \ /Scripts1:/src \ /Server2:localhost /Database2:MyDatabase /UserName2:Deployments /Password:my-secret-password </div>
which results in the error message:SQL Compare V14.7.2.20940 ==================================================================================================================================================================== Copyright © Red Gate Software Ltd 1999-2022 Beta (expires on Wednesday, 06 July 2022) Warning: Some settings are missing from the RedGateDatabaseInfo.xml file in the scripts folder '/src': default values will be used for any omitted setting. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify<br>that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)
-
It’s awesome that SQL Compare 14 now supports Linux via Docker! Just make sure Docker’s set up on your system, and then you can easily compare databases using the command provided. For more info, you can check out the Redgate documentation. Great feature for Linux users!
-
@David_Keaveny
Open SQL Server Configuration ManagerNavigate to SQL Server Network Configuration → Protocols for [Your Instance]Ensure TCP/IP is enabledRestart the SQL Server service after making changes -
David_Keaveny said:
This looks very helpful, especially for non-Windows based build systems. When I try to run the CLI based on the scripts, it fails to connect my local SQL Server - do we need to set up networking to allow the CLI access? There's no indication of it in the examples.
My script is:
<div>docker run --rm --interactive --tty \ --mount type=bind,source=/src/scripts,target=/src \ redgate/sqlcompare \ /IAgreeToTheEULA \ /Scripts1:/src \ /Server2:localhost /Database2:MyDatabase /UserName2:Deployments /Password:my-secret-password </div>which results in the error message:
SQL Compare V14.7.2.20940 ==================================================================================================================================================================== Copyright © Red Gate Software Ltd 1999-2022 Beta (expires on Wednesday, 06 July 2022) Warning: Some settings are missing from the RedGateDatabaseInfo.xml file in the scripts folder '/src': default values will be used for any omitted setting. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify<br>that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)
Sure! Your SQL Server connection issue likely happens because the Docker container sees `localhost` as itself, not the host machine. Try using `host.docker.internal` instead.
-
Still helpful in 2025, Thanks.
-
Is it still working in 2025? Anyone has idea about this?
-
Yes, it is working really fine in 2025. You can use it without any hesitation.
-
Nulls Brawl iOS offers a fun twist on the original Brawl Stars experience by unlocking all characters, skins, and resources from the start, letting players focus purely on gameplay without the usual grind. It’s a cool way to test out different strategies and brawlers in a more relaxed, sandbox-style environment—just keep in mind it's unofficial and not connected to Supercell.
-
It’s great to see that SQL Compare 14 now works on Linux through Docker! Once Docker is properly installed, you can run simple commands to compare databases. For detailed guidance, the Redgate documentation has everything you need.
-
Nulls Brawl for iOS is a great way to enjoy Brawl Stars with some cool custom features and tweaks you won’t find in the official game. It offers a fresh spin for players who want to try different skins, modes, or just mess around without restrictions. Just remember, since it’s a modded version, you’ll need to be careful about where you download it from and keep your device’s security in mind. If you’re a Brawl Stars ios fan looking for something extra, it’s definitely worth checking out!
-
This is fantastic news! Running SQL Compare 14 via Docker on Linux really opens up flexibility for cross-platform database comparisons. The command line example makes it straightforward to get started—looking forward to trying this out in my environment. Having this kind of downloadable content as a container image definitely simplifies deployment. Thanks for sharing!
-
Yes, it is working really fine in 2025. You can use it without any hesitation.
-
SQL Compare 14 now works on Linux via Docker. Set up Docker, run commands to compare databases, and follow Redgate’s docs for full instructions.
-
This is still working in late 2025. Thank you.
-
Does SQL Compare 14 support running from the command line on Linux, or is it limited to Windows only? I’m looking to automate schema comparisons. For anyone interested in growing their online presence alongside tech projects, this resource might help: https://toppfollowapks.com/
-
That's fantastic news about SQL Compare 14 supporting Linux via Docker! It really simplifies cross platform database comparison and makes workflows more flexible for developers and teams. I appreciate you pointing to the Redgate documentation, it helps users get started without confusion. I might even create an iCal template to track version changes and comparison schedules. Thanks for sharing this clear and useful update with the community for everyone today.
-
Equalizer APO is a powerful, open-source parametric equalizer designed exclusively for Windows. By operating directly at the system level via the Windows Audio Processing Object (APO) infrastructure, it allows you to apply unlimited filters, manage multichannel audio, and integrate VST plugins across all your applications with near-zero latency. It is exceptionally lightweight and provides professional-grade control over your sound without consuming significant CPU resources, making it the gold standard for Windows audio customization.
-
Interesting update about running SQL Compare 14 on Linux using Docker. It’s great to see more tools becoming compatible with Linux environments since many developers rely on containers and CI/CD workflows today.
Also, if anyone here is looking for the mod version of the Summertime Saga game, you can visit https://summertimesagas.com for more information and download options.
-
This is a really solid update for SQL Compare 14 being able to run the CLI on Linux via Docker is a big win, especially for teams working in mixed environments or CI/CD pipelines. The setup looks pretty straightforward, and using the container image, from Docker Hub makes it much easier to get started without worrying about local dependencies.
The example command is helpful, though I’d probably recommend using environment variables or secrets for passwords instead of passing them directly in the command for better security. Also, curious are there any limitations in the Linux container version compared to the Windows CLI yet, or is feature parity mostly there?
-
This is a huge step forward for DevOps teams who prefer Linux-based CI/CD pipelines over Windows agents. Running SQL Compare in a Docker container makes it so much easier to automate database deployments without the overhead of a full VM.
For anyone getting started, just make sure your Docker network can actually reach your SQL Server instances, especially if they are on a different subnet or behind a firewall. I usually run these migration scripts during my lunch break while I’m updating content for my mcdonald's menu Prices UK website, as it lets the schema comparison finish in the background while I work on other tasks. It’s definitely a more efficient workflow than the old manual methods and keeps everything much more organized!
Add comment
Please sign in to leave a comment.
As a basic example, you can use the following to compare two databases using the SQL Compare container image.
docker run --rm redgate/sqlcompare:14 /IAgreeToTheEULA \ /s1:my-server\\sql2019 /db1:database1 /u1:sa /p1:my-password \ /s2:my-server\\sql2019 /db1:database2 /u2:sa /p2:my-passwordHere is a link to a page on our documentation site to help you get started.