Red Gate forums :: View topic - SQL Compare synchronize script issue
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare synchronize script issue

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rgfriend



Joined: 12 Jun 2011
Posts: 11

PostPosted: Sat Jan 28, 2012 3:55 am    Post subject: SQL Compare synchronize script issue Reply with quote

I generated a scipt that synchronizes the testing database with production database.

Most of time the script works fine. But sometimes the script runs with errors. An example in the script, it alters a table to add a couple of columns, and right after that it inserts data into the table, then it failed at this step. I think this may because the alter table has not finished adding columns then the insert starts to process, although they are in right order, it seems the second transaction didn't wait for then end of the previous one.

I tried to run it second time, then it suceeded. So that means this may not happen all the time, but how can I fix issues like this?

Thanks
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Mon Jan 30, 2012 3:04 pm    Post subject: Reply with quote

Thank you for your post into the forum and sorry that you have encountered a problem.

Can you please reply with deatils of the exact error message you are experiencing?

This action will hopefully help myself and colleagues, identify the cause of your issue.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
rgfriend



Joined: 12 Jun 2011
Posts: 11

PostPosted: Mon Jan 30, 2012 5:28 pm    Post subject: Reply with quote

The error is something like cannot insert ....

I think my message is clear enough to show you what is the problem.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 889
Location: Red Gate Software

PostPosted: Mon Jan 30, 2012 6:18 pm    Post subject: Reply with quote

Thank you for your reply.

I can think of several reasons why the synchronization process cannot insert...

Hence why I requested the actual error message. If you wish me to continue to help you, please reply with the actual error message returned as to why the data cannot be inserted.

Sorry to be so blunt, but my Crystal Ball is not working today.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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