How can we help you today? How can we help you today?

Command Line Question

That's a cool feature, but any pointers on comparing two instances on the same server?

The following commands:
sqldatacompare.exe /s1:dbsrv\dev /database1:customer /s2:dbsrv\test /database2:customer | find /V "=="
sqldatacompare.exe /s1:[dbsrv\dev] /database1:customer /s2:[dbsrv\test] /database2:customer | find /V "=="
sqldatacompare.exe /s1:"dbsrv\dev" /database1:customer /s2:"dbsrv\test" /database2:customer | find /V "=="

Error out with:
Unexpected error: Could not load type
'RedGate.SQLCompare.BackupReader.ReadFromBackup.BackupDatabaseSource' from
assembly 'RedGate.SQLCompare.BackupReader, Version=6.0.0.614, Culture=neutral,
PublicKeyToken=7f465a1c156d4d57'.
Could not load type 'RedGate.SQLCompare.BackupReader.ReadFromBackup.BackupDataba
seSource' from assembly 'RedGate.SQLCompare.BackupReader, Version=6.0.0.614, Cul
ture=neutral, PublicKeyToken=7f465a1c156d4d57'.
System.TypeLoadException
at RedGate.SQLDataCompare.CommandLine.ProjectParameterUtilities.ConfigureData
Sources()
at RedGate.SQLDataCompare.CommandLine.Runner.LoadProject(String fileName)
at RedGate.SQLDataCompare.CommandLine.Runner.LoadProject()
at RedGate.SQLDataCompare.CommandLine.Runner.Run()
at RedGate.SQLDataCompare.CommandLine.Startup.Main(String[] args)


And this one:
sqldatacompare.exe /s1:<dbsrv\dev> /database1:customer /s2:<dbsrv\test> /database2:customer | find /V "=="

Errors out with:
The system cannot find the path specified.
ranjtl
0

Comments

2 comments

Sort by
  • Robert C
    Hi ranjtl,

    I believe you're referring to the SQL Data Compare 6 Alpha, which doesn't support the command line at the moment - that explains why you're seeing the error you are. It'll be fixed in the next release, of course.

    If you could post feedback relating to the SDC6 Alpha in the SQL Data Compare 6 Alpha forum, that'd be appreciated - it's more likely to get noticed by us as well there!

    Thanks,
    Robert
    Robert C
    0
  • JonathanWatts
    Moved to the correct forum.

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.