Red Gate forums :: View topic - SQL Data Compare 8.1.0.4 generates script with syntax errors
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

SQL Data Compare 8.1.0.4 generates script with syntax errors

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
scottdavidnelson



Joined: 28 Jan 2011
Posts: 2

PostPosted: Fri Jan 28, 2011 4:28 pm    Post subject: SQL Data Compare 8.1.0.4 generates script with syntax errors Reply with quote

I've had a few occurrences where SDC generates scripts (large scripts) with syntax errors in them. The syntax errors display after part of the script has executed.

E.g., after ~44,000 rows have been inserted, it displays this error:

Error occurred executing synchronization:
Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
The variable name '@pv' has already been declared. Variable names must be unique within a query batch or stored procedure.
Incorrect syntax near '('.

is there a fix available for this issue?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 31, 2011 3:10 pm    Post subject: Reply with quote

Thanks for your post.

I believe this issue only occurs when using the 'split transactions' option.

It should be fixed in the latest cumulative patch, found here

This fix isn't mentioned in the list of fixes, but that's only because it was originally reported as a SQL Packager problem. (SQL Packager uses the SQL Data Compare engine for the data part)
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
jcollum



Joined: 15 Apr 2009
Posts: 3

PostPosted: Wed Mar 09, 2011 11:50 pm    Post subject: Reply with quote

Nope, this is happening for me and the Split Transactions was turned off. In my case I'm moving about 400k rows and seeing syntax errors. Which is really frustrating because these scripts take a long time to run. I'll try that patch if it continues.
Back to top
View user's profile Send private message
ahmannj



Joined: 06 Jan 2006
Posts: 13
Location: Minneapolis, MN. USA

PostPosted: Thu Mar 10, 2011 8:53 pm    Post subject: Syntax error in DC 8.1.1.19 Reply with quote

I just saw a similar syntax error doing a data sync (single table) with 8.1.1.19. 10M rows of random names and addresses generated by SQL Data Generator - nothing fancy.

I had seen similar issues in previous version, usually recompare and resync worked after the initial failed attempt. This last time, I just used SQL's import wizard to copy the data, rather than retry via DC.
Back to top
View user's profile Send private message
kalam



Joined: 08 Jun 2011
Posts: 1

PostPosted: Wed Jun 08, 2011 12:16 am    Post subject: Reply with quote

I have same problem with 9.0.0.117 while trying to sync 40k rows...
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Jun 08, 2011 9:34 am    Post subject: Reply with quote

Thanks for posting.

We've reproduced this issue in tests now, so we should have a fix fairly soon.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed Jun 15, 2011 8:13 pm    Post subject: Reply with quote

A patch to address this issue is now available here

Could you please let us know if this fixes the problem?
Back to top
View user's profile Send private message
Adam Hodge



Joined: 06 Mar 2012
Posts: 3

PostPosted: Tue Mar 06, 2012 2:54 pm    Post subject: Reply with quote

Thanks for sharing the info with us! Just what need! I have the same problem with 9.0.0.117.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group