Calling SQL Compare from a command line of via COM

Brian Donahue

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.

Regards,

Brian Donahue
Red Gate Technical Support

"Jimmy Tharpe" <jimmy@aps-soft.com> wrote in message
news:xLzoW3gWEHA.3028@server53...
> As part of my build process (I'm a software developer), I need to generate
a
> sync script using SQL Compare. Can I call SQL Compare from the command
line
> 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
>
>

Brian Donahue

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.