running sqlcompare.exe command line to create snapshot
krock23
Posts: 6
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
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
This discussion has been closed.
Comments
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.