redgate/sqlcompare repository overview

⁠What is SQL Compare?

SQL Compare is the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.

71% of the Fortune 100 use SQL Compare to compare SQL Server databases – because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time.

Whether you need to deploy changes or explore the differences between two SQL Server databases, SQL Compare helps you do the job quickly, simply, and with zero errors.

⁠What is this image?

This image contains the SQL Compare command line interface and all the requisite dependencies.

⁠How to use this image

⁠To compare two databases

docker run --rm \
    redgate/sqlcompare \
        /token:"<personal-access-token>" \
        /email:"<email>" \
        /s1:my-server\\sql2019 \
        /db1:database1 \
        /u1:sa \
        /p1:my-password \
        /s2:my-server\\sql2019 \
        /db2:database2 \
        /u2:sa \
        /p2:my-password

Replace the following:

• <personal-access-token> and <email> with your personal access token and associated email address. View our documentation on personal access tokens⁠ to get started.

The filesystem in a container is isolated from the rest of the system so you should use --mount⁠ to pass directories through to SQL Compare, for example when working with scripts folders and project files.

You can find more information at our documentation site⁠ and specifically the "Using the command line on Linux⁠" page.

⁠Licensing

You will need a SQL Compare Professional license to use the command line. If you don't have a license, you can use the command line on a trial license for 14 days.

⁠Links

• Redgate⁠
• SQL Compare⁠
• Redgate Support⁠
• SQL Compare on Linux UserVoice⁠