SQL Compare 14 Command Line on Linux

Rob C

SQL Compare 14 has now been released and a new beta feature is that the command line interface can now be run on Linux, using a Docker container. The only thing you need to do to use it is to ensure Docker is installed on your Linux machine. The SQL Compare 14 container image is now live on Docker Hub.

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-password<br>

Here is a link to a page on our documentation site to help you get started.

• Using the command line on Linux

trurl

This is awesome! 
Gave is a try, having issue with stored proc referencing custom data type:

 Column, parameter, or variable #1: Cannot find data type 

This worked with sql compare 12 windows same setup. Where issues can be reported for sql compare docker 14? 

Roseanna

Hi everyone,

To find out more about SQL Compare 14, check out this product learning article.

Cheers,

Roseanna 

David_Keaveny

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:

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

    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

David_Keaveny

Oops, never mind; I think the password was wrong!

#FacePalm

talharizwaan

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:

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

    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

wow, it looks rpomising,I am gonna give it a try and update you guys here . Thanks.

James78

Wow, this looks promising! I'm definitely going to give it a try and will update you all here. Thanks!

hurricanesupplier

Amazing concept I will try it as well after I finish playing Nulls Brawl game with my friends. It really inspires me how these game are made and how they can hook you, but it is people like us that keep them working I am proud of myself.

Leon_1

David_Keaveny said:

Oops, never mind; I think the password was wrong!

#FacePalm

Yes. I also get the same error when i accidently typed in the wrong password when connecting with the bsd brawl server. Thanks for pointing it out.

rosy76

hurricanesupplier said:

Amazing concept I will try it as well after I finish playing Nulls Brawl game with my friends. It really inspires me how these game are made and how they can hook you, but it is people like us that keep them working I am proud of myself.

Very cool! It's great to see you're inspired by how games like Nulls Brawl are made. Playing games is a great way to connect with friends. and explore creativity Enjoy the game and feel proud of your contribution to its success!

David44

"SQL Compare 14 on Linux sounds like a powerful tool for database syncing! It's great to see command-line utilities getting better cross-platform support. By the way, if you're into gaming during your breaks, check out Nulls Brawl—it's a fun way to unwind. Keep up the awesome tech posts!"

highlighter

I have a question! Do I have to use the docker run command separately on Linux to compare with others? BSD Brawl 

johnfreeman

SQL Compare 14's support for Linux through Docker is a fantastic step forward for cross-platform database management! It's great to see such tools becoming more accessible. By the way, during my breaks from exploring tech like this, I’ve been enjoying Нулс Бравл with my friends, it’s a fun way to relax and recharge. Looking forward to more updates like this.