invalid date format in database synchronisation

• 
  I'm sorry that you're experiencing this issue, it seems that this something that has been introduced into SQL Data Compare 7. The developers are well aware of this problem and are working on a fix for it as we speak. There should be a patch released within the next few weeks. I will notify you as soon as it is available.
  
  You may be able to work around the issue for the time being by outputting the synch script and running it in your SQL Server sql editor. Making sure that you manually add SET LANGUAGE 'US_ENGLISH' before running the script.

  Ben Pinchen August 22, 2008 04:44

  - 0 +
• 
  same problem here - hopefully there is a fix very soon
  
  SET LANGUAGE 'US_ENGLISH' worked so far - (but now i get different errors - will post em in a new topic)

  toebens September 22, 2008 08:37

  - 0 +
• 
  To Ben Pinchen:
  
  I have too many problems with datetime format, I use Italian language, but I think it may resolve with change of the script, for example, from:
  
  UPDATE [dbo].[aspnet_Membership]
  SET [LastLoginDate]='2008-09-25 07:22:33.920'
  WHERE [UserId]='1d6436d0-ac6d-4f1f-8cfc-a78308746c58'
  
  to:
  
  UPDATE [dbo].[aspnet_Membership]
  SET [LastLoginDate]=CONVERT(datetime, '2008-09-25 07:22:33.920', 121)
  WHERE [UserId]='1d6436d0-ac6d-4f1f-8cfc-a78308746c58'
  
  If SQL Data Compare will write this script for me, I will continue without copy, modify and execute of script.
  Thank you.

  jnet September 25, 2008 05:51

  - 0 +
• 
  This problem ought to be fixed in version 7.1 - if it isn't, please tell us so we can fix it properly .

  Michelle T September 25, 2008 09:48

  - 0 +

Add comment

Please sign in to leave a comment.