SQL Compare Command Line Snapshot Comparison

claireh

Hi,

I am using SQL Compare Pro Command line to compare database snapshot produced by SQL Compare. When sqlcompare.exe could not find one of the snapshot, it produced the following error message. Even though the output clearly stated it could not find the snapshot file, it also ended with some ugly application error message (started with "System.IO.DirectoryNotFoundException")

Is there anyway to remove the application error message in the end?



SQL Compare Command Line V6.0.0.1410
================================================================================================================================
Copyright c Red Gate Software Ltd 1999-2007

Serial Number:002-001-062127-9ADE

Registering databases
Unexpected error: Could not find a part of the path 'C:\Program Files\Claire\20070701\SQLServer1_MyDatabase.snp'.
Could not find a part of the path 'C:\Program Files\Claire\20070701\SQLServer1_MyDatabase.snp'.
System.IO.DirectoryNotFoundException
at RedGate.SQLCompare.CommandLine.CommandProcessor.ThrowProcessThreadException()
at RedGate.SQLCompare.CommandLine.CommandProcessor.RunComparison()
at RedGate.SQLCompare.CommandLine.CommandProcessor.Run()
at RedGate.SQLCompare.CommandLine.Startup.Main(String[] args)

claireh

Could someone please let me know whether this is bug from SQL Compare?

Thanks
Claire

JonathanWatts

Claire,

Sorry, about your problems. Yes SQL Compare command line doesn't cope very well when it cannot locate the snapshots that you specify. It is rather ugly and we will be fixing this in the next point release.

Regards,

Jonathan

claireh

Hi Jonathan,

Thanks for your reply. I recall similar issues also occurred on Version 5.

Please address this issue as your earliest convenience.

Thanks
Claire