Red Gate forums :: View topic - Modify deployment script capability
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Data Compare
MySQL Data Compare forum

Modify deployment script capability

Search in MySQL Data Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
mniAP



Joined: 15 Mar 2012
Posts: 1

PostPosted: Thu Mar 15, 2012 6:29 pm    Post subject: Modify deployment script capability Reply with quote

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 @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 87
Location: Red Gate Software

PostPosted: Fri Mar 16, 2012 7:22 pm    Post subject: Reply with quote

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
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