What are the challenges you face when working across database platforms? Take the survey

Calling SQL Compare from a command line of via COM

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 28, 2005 6:44AM in SQL Compare Previous Versions
Hi Jimmy,

SQL Toolkit depends on the .net Framework for its' runtime environment,
so you will absolutely need .net installed. We no longer support the COM
versions of SQL Compare and Data Compare that we used back in version 2.

Because people expect different things from a command-line program,
we've left this functionality to programmers with the SQL Toolkit. SQL
Compare and Data Compare offer a bewildering set of options which make it
difficult to decide how to support them via a command line.


Brian Donahue
Red Gate Technical Support

"Jimmy Tharpe" <jimmy@aps-soft.com> wrote in message
> As part of my build process (I'm a software developer), I need to generate
> sync script using SQL Compare. Can I call SQL Compare from the command
> or via COM (*not* .NET)? I simply need to pass a project file name and an
> output file name.
> I looked at SQL Toolkit and it is way more than I need (and too expensive
> for such a simple task) plus it uses .NET which my build automation tool
> does not currently support (it does support calling COM objects though).
> Any help?
> Thanks -
> --
> -Jimmy
> Blog: http://research.remobjects.com/blogs/jimmy/
> Furl: http://www.furl.net/members/jimmytharpe


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    From version 3.2, SQL Toolkit now include pre-built command-line utilities for SQL Compare, Data Compare, and Packager. The command-line tools allow scheduling, batching, and pre-selection of tables and objects to synchronize.
This discussion has been closed.