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

Help- 9009 error that will not let me MSBuild script succeed

Hello,

I am having an issue with running the command-line portion of sqlcompare 7.1. We are using it to ensure our remote development db schema stays syncronized with our local development db schema.

I did read on another post that addig the /allowIdenticalDatabases switch would stop this from returning an error, but that isn't the case.

Here is our command that is being ran to return the 9009 exit code:
(It is on one line, but I have broken it up into seperate lines for reading purpose)

sqlcompare
/server1:GILocalDevelopment
/username1:XXXXX
/database1:XXXXX
/password1:XXXXX
/server2:GIRemoteDevelopment
/username2:XXXXX
/password2:XXXXX
/database2:XXXXX
/exclude:Assembly
/sync
/allowIdenticalDatabases
/includeIdentical:true

I get a list of identical tables and the sync is actually completing successful, but just returning a failure. Thsi is very important, as it is stopping our build servre from producing successful build. Any help would be greatly appreciated.

Thank You
ryan_helms
0

Comments

1 comment

  • ryan_helms
    Hello,

    I found the solution after playing around a bit. I added the WorkingDirectory attribute to the <Exec> tag and poof, it worked.

    Working Example:

    <Exec WorkingDirectory="C:\Program Files\Red Gate\SQL Compare 7\" ~>

    Hope this helps someone.

    Thanks[/b]
    ryan_helms
    0

Add comment

Please sign in to leave a comment.