Commandline sync and scriptfile options
I am trying to setup a continuous integration using TFS Build. Problem is, the /scriptfile argument does not seem to work unless /sync is also specified. I need to generate an update script that I can run at a later time WITHOUT having the sqlcompare do a database synchronization.
The following command is an example of what I'm executing during my build:
sqlcompare /scr1:"C:\SchemaPath" /db2:DBName /s2:ServerName /ScriptFile:"C:\Update.sql" /IgnoreParserErrors /f
Using the above example will not generate a script file unless I also pass the /sync option.
I really hope that I have just over looked something and this is not by design. I really need to have scripts executed at a later time, NOT during the TFS Build.
Thanks in advance for any help.