![]() SQL Compare’s command line interface allows access to all the functionality of the UI tool, and allows us to introduce automation and scheduling, for example by invoking the command line from a batch file or PowerShell script, and then perhaps executing the script as a scheduled Agent job. Getting started with automating database schema comparisons My example compares the schema of two live databases, but you can equally well run the comparisons using scripts folders, or SQL Compare Snapshots. This article is not intended as a tutorial on the various command line switches, options and filters, but I do cover some of those I found useful when using the command line for the first time. There are CLIs for Windows and for Linux. Generate an HTML report of the changes that were made.Automatically generate a deployment script that when executed on the target will makes its schema the same as the source.The article provides the basis for a simple, but automated database deployment process that will ![]() ![]() Outside of his day-to-day schedule, he blogs, shares tips on forums and writes articles on his Data Messenger blog. In the past 3 years, he has expanded his focus to coding in R for assignments relating to data analytics and data science. Feodor has worked with SQL Server for over 15 years, specializing in database architecture, Microsoft SQL Server data platform, data model design, database design, integration solutions, business intelligence, reporting, as well as performance optimization and systems scalability. This is a guest post from Feodor Georgiev.
0 Comments
Leave a Reply. |