running sqlcompare.exe command line to create snapshot

krock23krock23 Posts: 6
edited May 23, 2005 6:40AM in SQL Compare Previous Versions
Hi, I am currently using SQL Compare version 3.2.05.
I need to get a snapshot of a client's database and use the snapshot to compare it to my development SQL Server. Can I run the command line sqlcompare.exe on the client's machine and do I have to register any DLL's on that machine to get it to run?

Regards,
Ken

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Ken,

    Thanks for asking. dll registration is a COM thing, and since the SQL Bundle uses .NET technology, all that you need to do is copy the appropriate dll files. SQLCompare needs RedGate.SQL.Shared.dll and RedGate.SQLCompare.Engine.dll. You'll probably also need RedGate.Licensing.client.dll and RedGate.Licensing.Helper.dll if the program is unregistered on that particular machine.

    Copy all of these files into the same folder as sqlcompare.exe and it should work just fine.

    Please keep in mind that sqlcompare.exe (the command-line version of SQL Compare) is not included in the 'standard' SQL Bundle, but it's part of the developer edition bundle.
This discussion has been closed.