/scriptfile Error

Comments

• Robert C Redgate › Posts: 425 Silver 2

  September 24, 2009 6:10AM

  Hi,
  

  brigzy wrote:

  Here is my command line:
  "C:\Program Files\Red Gate\SQL Compare 8\sqlcompare.exe" /Server1:Partner-Dev /Database1:rdb_partner_chall /Server2:Partner-Dev /db2:partner_chall
  /scriptfile:"C:\test.sql" /force

  
  I think you have a line break between "partnet_chall" and "/scriptfile"; if you remove this and enter the whole command as a single line, it should work.
  
  Cheers,
  Rob

  Robert Chipperfield
  Red Gate

  0 · Share on Twitter
• brigzy Posts: 14

  September 24, 2009 6:16AM

  Robert wrote:

  Hi,
  

  brigzy wrote:

  Here is my command line:
  "C:\Program Files\Red Gate\SQL Compare 8\sqlcompare.exe" /Server1:Partner-Dev /Database1:rdb_partner_chall /Server2:Partner-Dev /db2:partner_chall
  /scriptfile:"C:\test.sql" /force

  
  I think you have a line break between "partnet_chall" and "/scriptfile"; if you remove this and enter the whole command as a single line, it should work.
  
  Cheers,
  Rob

  
  Thats it! great, thank you for fast response Rob

  Richard

  0 · Share on Twitter
• brigzy Posts: 14

  September 24, 2009 7:21AM

  Hi
  when running an SQL script generated by SQLCompare we get this error :
  
  1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line 1
  Incorrect syntax near 'ï'.
  /*
  Run this script on:
  
  Partner-Dev.partner_chall - This database will be modified
  
  to synchronize it with:
  
  Partner-Dev.rdb_partner_chall
  
  You are recommended to back up your database before running this script
  
  Script created by SQL Compare version 8.1.0 from Red Gate Software Ltd at 24/09/2009 11:44:10
  
  */
  SET NUMERIC_ROUNDABORT OFF
  1> 2>
  

  ---

  
  OSQL seams to see some odd characters at the beginning of the file?

  Richard

  0 · Share on Twitter
• brigzy Posts: 14

  September 24, 2009 7:29AM

  brigzy wrote:

  Hi
  when running an SQL script generated by SQLCompare we get this error :
  
  1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line 1
  Incorrect syntax near 'ï'.
  /*
  Run this script on:
  
  Partner-Dev.partner_chall - This database will be modified
  
  to synchronize it with:
  
  Partner-Dev.rdb_partner_chall
  
  You are recommended to back up your database before running this script
  
  Script created by SQL Compare version 8.1.0 from Red Gate Software Ltd at 24/09/2009 11:44:10
  
  */
  SET NUMERIC_ROUNDABORT OFF
  1> 2>
  

  ---

  
  OSQL seams to see some odd characters at the beginning of the file?

  
  I found I am ok if I use sqlcmd instead, which supports UTF-8.

  Richard

  0 · Share on Twitter
• Robert C Redgate › Posts: 425 Silver 2

  September 24, 2009 8:56AM

  Good stuff - those characters at the front are almost certainly unicode byte order marks, in case you're interested!

  Robert Chipperfield
  Red Gate

  0 · Share on Twitter
• Michelle T Posts: 566 Gold 1

  September 24, 2009 9:16AM

  You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the setting is in Application Options, accessible from the Tools menu.

  Software Developer
  Redgate Software

  0 · Share on Twitter
• brigzy Posts: 14

  September 24, 2009 9:24AM

  Michelle Taylor wrote:

  You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the setting is in Application Options, accessible from the Tools menu.

  
  I am new to SQLCompare just today, so I appologise if I miss the obvious...
  
  The script is being generated by SQLCompare (command line), so I am not sure the options you mention are available.
  
  Using SQLCMD as an alternative to OSQL is working solution for me.
  
  I do have a problem at the momentthough see : post
  http://www.red-gate.com/messageboard/viewtopic.php?t=9653

  Richard

  0 · Share on Twitter
• Michelle T Posts: 566 Gold 1

  September 24, 2009 9:28AM

  /scriptencoding is the command line switch you're looking for - see the docs for more details.

  Software Developer
  Redgate Software

  0 · Share on Twitter
• brigzy Posts: 14

  September 24, 2009 9:31AM

  Michelle Taylor wrote:

  /scriptencoding is the command line switch you're looking for - see the docs for more details.

  Ah yes that would have done it..
  Many Thanks

  Richard

  0 · Share on Twitter