Input string was not in a correct format...

mrounds

Hello all,

I'm getting an error I'm hoping someone can help me with, I'm sure it's a bonehead mistake on my part...

I'm using the following in a batch script to create a bunch of snapshots from a dev system and our production system. Our dev box is running SQL Server 2008, production is running 2005.

My problem is when comparing the snapshots and generating a report from them. I'm running through over a dozen databases, generating reports for each one, but ONE fails, with the following error message (command line progress message):

<sql compare version is displayed>

Registering databases
Unexpected error: Input string was not in a correct format.
Input string was not in a correct format.
System.FormatException........





I'm using the following to generate the snapshots:
%SQLCOMP% /s1:<servername> /db1:analytics /mksnap:prod.analytics.snp /f

I'm then using the following to compare the snapshot files:

%SQLCOMP% /sn1:prod.analytics.snp /sn2:dev.analytics.snp /report:prod-dev.analytics.html /rt:Interactive /o:ip,iw,ift,icn,iu,iup /exclude:Table:\[_.*\]^|_bku

Any ideas?

Thanks your for time.

Simon C

Hi mrounds; what version of SQL Compare are you using? Is the stack trace of the FormatException available?

Simon

mrounds

I started with v7 and upgrade to v7.1 yesterday afternoon. I'm still getting the error after the update.

Here's the entire message returned:

Registering databases
Unexpected error: Input string was not in a correct format.
Input string was not in a correct format.
System.FormatException
at RedGate.SQLCompare.CommandLine.CommandProcessor.d()
at RedGate.SQLCompare.CommandLine.CommandProcessor.e()
at RedGate.SQLCompare.CommandLine.CommandProcessor.Run()
at RedGate.SQLCompare.CommandLine.Startup.a(String[] )

mrounds

FWIW - Using the GUI, I can run a compare against this problem database and it works fine. It's too bad I can't save the interactive report in the GUI to html like you can with the command line.

Simon C

Have you tried running the compare without the /exclude option?