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

Input string was not in a correct format...

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.
mrounds
0

Comments

4 comments

Sort by
  • Simon C
    Hi mrounds; what version of SQL Compare are you using? Is the stack trace of the FormatException available?

    Simon
    Simon C
    0
  • 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
    0
  • 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.
    mrounds
    0
  • Simon C
    Have you tried running the compare without the /exclude option?
    Simon C
    0

Add comment

Please sign in to leave a comment.