Activity overview
Latest activity by ddorval
/include:StaticData with /option:NoTransactions not working
Our msbuild build script is executing sqlcompare twice with everything the same except the 2nd time we include NoTransactions on the option list.
/options:Default,IgnoreTSQLT,IgnoreUsersPermissions...
incremental updating of database
As part of the Deploy process of our build system I'm trying to update a database in an unknown state to the latest build. (a script is also generated)
This was working before comparing the scripts...
As a work around I wrote a command line application that also uses SharpSVN to connect to svn with the sole purpose of caching the credentials for sqlcompare. We are running sqlcompare.exe from within an msbuild script being executed using the msbuild api objects (not msbuild.exe) within a .net Windows Service...so there is many layers of no UI. / comments
As a work around I wrote a command line application that also uses SharpSVN to connect to svn with the sole purpose of caching the credentials for sqlcompare. We are running sqlcompare.exe from wit...
I am using svn credentials that have access, that's why it works once the credentials are cached. It would be nice to be able to specify the credentials to use for svn when connecting for migration scripts. SVN isn't using Windows Authentication. / comments
I am using svn credentials that have access, that's why it works once the credentials are cached. It would be nice to be able to specify the credentials to use for svn when connecting for migration...
I'm not sure how we have SVN configured. I know we use our network credentials to login to svn but we do have to actually login. Our build server is not on the domain anyway so I do not think it is using Windows Authentication. As a work around I created a console application that uses sharpsvn to do an svn info command and cache the credentials. Adding that to the msbuild script before the call to sqlcompare allows sqlcompare to work.
I don't know all the details about how all the different svn's work but when testing at the command line all I had to do was call svn info and then sqlcompare would work but when running inside an msbuild script svn info wasn't enough and I had to write a program to use sharpsvn. / comments
I'm not sure how we have SVN configured. I know we use our network credentials to login to svn but we do have to actually login. Our build server is not on the domain anyway so I do not think it is...
command line Error: Unable to connect to a repository at URL
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 fro...
Also when comparing 2 scripts folders I get
Error: Object reference not set to an instance of an object. / comments
Also when comparing 2 scripts folders I get
Error: Object reference not set to an instance of an object.
/include:staticdata including all tables
I added the /include:staticdata because I want to include the static/linked tables data in my deployment scripts. This switch seems to include ALL tables not just static/linked tables.
I'm comparin...