using the command line to script a database

• 
  The switches you're looking for are /server1: and /server2: (or /s1: and /s2:). So your command line would look like the following:
  
  sqldatacompare /server1:SERVERNAME /db1:WidgetStaging /server2:SERVERNAME /db2:WidgetProduction /ScriptFile:"C:\Scripts Folder\WidgetSyncScript.sql"

  Michelle T August 19, 2009 09:52

  - 0 +
• 
  cheers for that... even simpler for setting up a static project, you can use an existing project definition (saves server,db and unames and pwds and everything else) ie...
  
  sqldatacompare /project:"C:\Documents and Settings\user\My Documents\SQL Data Compare\SharedProjects\LocalServercRemoteServer.sdc" /ScriptFile:"C:\Data\scripts\OutputSql.sql"

  digi-dave August 27, 2009 07:13

  - 0 +
• 
  Im trying the following from a batch file:-
  
  cd "c:\program files\Red gate\SQL Data Compare 8"
  
  sqldatacompare.exe /server1:INVERNESS\SQL2005 /db1:GREGSTEST_DEV /scr2:"C:\Documents and Settings\gsuttie\Desktop\SQL continuos\ScriptsFolder\GREGSTESTSCRIPTS"
  
  /synchronize
  
  pause
  
  I have also tried /sync both erroring - where am i going wrong?
  
  Thanks
  Gregor

  gsuttie September 09, 2009 04:46

  - 0 +
• 
  Hi
  
  Your syntax there looks fine to me - what is the error message you get when this fails?

  RogerHart September 09, 2009 10:03

  - 0 +

Add comment

Please sign in to leave a comment.