I finally got migration scripts to work from the command line but after moving the updated command to the build script it fails on the build machine.
I copied the actual sqlcompare command used from the log and replaced the local paths with network paths (so I'd be reusing the same folders/files) except for /scriptfile and it worked fine. I then cleared the Authentication Data in Tortoise SVN and now I get the same error running from my machine.
I am specifying the following switches:
/scripts1:"local database folder of branch being built"
/scripts2:"local database folder of Trunk"
/scriptfile:"file name/path of output"
/migrationsfolder:"local migration folder of branch"
/scriptsfolderxml:"local file with contents from db extended property"
/revision1:"revision number of branch"
/revision2:"revision number of trunk"
I've verified the username and password are correct. svn info with the url from the error and the username and password specified works.
Our build system actually copies the branch being build to a new branch with the build number then gets that branch for the build. To save having to maintain the /scriptsfolderxml file I thought I could be clever and update that file as part of the build with the url of the build branch. Doing this didn't give an Error but also didn't use the migration scripts .
It would also be nice to not have to specify the /scriptsfolderxml since that url is also in the migrationScript file.