redgate/sqldatacompare repository overview

⁠What is SQL Data Compare?

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents.

You can work with live databases, backups, or SQL scripts in source control. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

SQL Data Compare helps you compare and deploy changes quickly, simply, and with zero errors.

⁠What is this image?

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

⁠How to use this image

⁠To compare two databases

docker run --rm \
    redgate/sqldatacompare \
        /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 Data 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 need a SQL Data 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 Data Compare⁠
• Redgate Support⁠