Comparing and Deploying SQL Server Databases Using the SQL Compare Command Line on Linux or Windows

SQL Compare Command Line

SQL Compare now includes a Linux-based command line interface (CLI) as well as a Windows-based one for doing schema comparison and deployments of SQL Server databases. This article offers examples of CLI scripts for various schema comparison tasks to get you up and running with either version.

You may also like:  Data and Schema Comparison Tools for MS SQL Server Databases (Part 1)

Contents

On investigating the new SQL Compare command line for Linux, I wanted to try out a range of its features, so I installed it directly on a Linux-based Synology NAS server and used it to access SQL Server instances on the network and to process files such as backups directly on the Linux filesystem.