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
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