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

more verbose errors?

I'm getting an error (this is from the log)

Synchronizing databases
Error: Error Comparing Scripts/DB vs <server>/<db> : Incorrect syntax near '.'.

when running from the cmd with the /sync flag

How can I get more info as to what is causing this?
austrianfoodispuke
0

Comments

4 comments

Sort by
  • Chris Auckland
    can you post the entire command you are using?
    Chris Auckland
    0
  • austrianfoodispuke
    It's just running the "sqlcompare.exe -blah -blah -blah" tool

    It runs ok, but one of the scripts is causing it to fail and I don't know which one.

    Using the /verbose switch does not help either
    austrianfoodispuke
    0
  • Chris Auckland
    it's probably some invalid SQL in one of the objects being compared. Can you track down which object it is failing on? You may get a better error message doing this through the UI.

    If you would like us to take a look at the problem, can you send the source/target scripts to support@red-gate.com?
    Chris Auckland
    0
  • Chris Auckland
    to add to this; if you use the UI you can also turn on the logging facility. This might help to identify the object.

    to turn logging on, open the UI, then left-click the SQL Compare logo in the title bar and select 'Enable Logging >> Verbose'
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.