SQL Compare synchronize script issue

rgfriend · January 27, 2012 9:55PM

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

Eddie D · January 30, 2012 9:04AM

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

rgfriend · January 30, 2012 11:28AM

The error is something like cannot insert ....

I think my message is clear enough to show you what is the problem.

Eddie D · January 30, 2012 12:18PM

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

SQL Compare synchronize script issue

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk