What are the challenges you face when working across database platforms? Take the survey
Options

Modify deployment script capability

mniAPmniAP Posts: 2
edited March 16, 2012 2:22PM in MySQL Data Compare
Hi
Just downloaded the trial today
I'm moving data from one mysqldb to another. It's a direct transfer from staging to prod
The mysql dbs are in different servers. The schema transfer worked without problems.
However when I run the data transfer, I get an error for a Set Foreign Key Checks statement.

I think the way around in this case is to just ignore those statements and try however there is no way to do this. Could you suggest an alternative.

Also is there any way to overwrite data in the target database instead of update

I've included the error below:

Bug report generated at 3/15/2012 10:17:52 AM
Program version 1.0.0.351
System.Exception: When deploying couldn't execute the statement:SET @FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @UNIQUE_CHECKS, UNIQUE_CHECKS=0;

Comments

  • Options
    Hi

    Thanks for the report. Which version of MySQL server is on staging and which is on production?

    It'd also be great to know which storage engines you are using on both.

    One final question, could you run the script manually and send us the error that is displayed? Hopefully this will give us more information and help resolve the issue.

    Thanks again,
    Michael
Sign In or Register to comment.