SQL Compare synchronize script issue

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Compare synchronize script issue

Postby rgfriend » Sat Jan 28, 2012 3:55 am

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
rgfriend
 
Posts: 11
Joined: Sun Jun 12, 2011 4:46 pm

Postby eddie davis » Mon Jan 30, 2012 3:04 pm

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby rgfriend » Mon Jan 30, 2012 5:28 pm

The error is something like cannot insert ....

I think my message is clear enough to show you what is the problem.
rgfriend
 
Posts: 11
Joined: Sun Jun 12, 2011 4:46 pm

Postby eddie davis » Mon Jan 30, 2012 6:18 pm

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron