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

SQLCompare.exe - stops after listing an incomplete obj list

When running a sqlCompare through the command line, it just stops. No success message and worse off NO return code. However it DOES do the synchronize.

Tail end of output . . .

StoredProcedure dbo.hs_select_CT_ExtSheetName == ==
StoredProcedure dbo.hs_insert_Contact == ==
StoredProcedure dbo.hs_Select_CT_Installers == ==
StoredProcedure dbo.hs_insert_ContactAddress == ==
StoredProcedure dbo.hs_Select_CT_InventorySelection == ==
StoredProcedure dbo.hs_insert_ContactPhoneNumber == ==

The same compare run through the UI displays the entire list of objects.

The problem I'm having is that I run the sqlCompare in an automated script that needs a return code. The list should also match the list that I see running it from the UI. Since the tool is not returning any values, my Deployment script HALTS. This looks like a BUG in the tool. Please respond, because I'm running into a tight deadline to get this resolved.

Thanks,

Bill Reiss
Sr. Application Developer
HD Supply
breiss
0

Comments

1 comment

Sort by
  • Michelle T
    If you can send a snapshot or backup of the database and a copy of the exact command line that you're using (and any XML files you might be using for parameter setting) to michelle.taylor@red-gate.com I'll have a look at it and see if I can reproduce the problem / tell you what's going wrong.

    Even just the command line / parameters file and some idea about what's in the database (size of schema / number of database objects, general distribution of object types) might let me figure out what's going on with the lack of return code.
    Michelle T
    0

Add comment

Please sign in to leave a comment.