How can we help you today? How can we help you today?
Michael Christofides
bstewart wrote: Unfortunately, the log doesn't reveal much other than how long each part of the comparison is taking: 13:03:01.683|Debug |PopulationLogger |5 |ProgressTask:Populating DB test1 13:03:01.687|Debug |PopulationLogger |5 |ProgressTask:Populating Dependencies 13:03:08.793|Debug |PopulationLogger |5 |ProgressTask:Populating Tables 13:03:11.373|Debug |PopulationLogger |5 |ProgressTask:Populating Columns 13:03:11.549|Debug |PopulationLogger |5 |ProgressTask:Populating Indexes 13:03:14.031|Debug |PopulationLogger |5 |ProgressTask:Populating Constraints 13:03:14.031|Debug |PopulationLogger |5 |ProgressTask:Populating Index Constraints 13:03:41.769|Debug |PopulationLogger |5 |ProgressTask:Populating FK Constraints 13:04:31.104|Debug |PopulationLogger |5 |ProgressTask:Populating Views 13:04:31.155|Debug |PopulationLogger |5 |ProgressTask:Populating Routines 13:04:31.180|Debug |PopulationLogger |5 |ProgressTask:Populating Triggers 13:04:32.511|Debug |PopulationLogger |5 |ProgressTask:Populating Events 13:04:32.536|Debug |PopulationLogger |5 |ProgressTask:Populating DB test2 13:04:32.536|Debug |PopulationLogger |5 |ProgressTask:Populating Dependencies 13:04:37.949|Debug |PopulationLogger |5 |ProgressTask:Populating Tables 13:04:40.106|Debug |PopulationLogger |5 |ProgressTask:Populating Columns 13:04:40.263|Debug |PopulationLogger |5 |ProgressTask:Populating Indexes 13:04:43.214|Debug |PopulationLogger |5 |ProgressTask:Populating Constraints 13:04:43.214|Debug |PopulationLogger |5 |ProgressTask:Populating Index Constraints 13:05:08.606|Debug |PopulationLogger |5 |ProgressTask:Populating FK Constraints 13:05:58.547|Debug |PopulationLogger |5 |ProgressTask:Populating Views 13:05:58.582|Debug |PopulationLogger |5 |ProgressTask:Populating Routines 13:05:58.586|Debug |PopulationLogger |5 |ProgressTask:Populating Triggers 13:05:59.877|Debug |PopulationLogger |5 |ProgressTask:Populating Events 13:06:00.948|Debug |Event Aggregator |1 |:Sending message #Limb.#paD 13:06:01.285|Debug |Event Aggregator |1 |:Sending message #Limb.#pbD 13:06:02.674|Debug |Event Aggregator |1 |:Sending message #Limb.#obD Thank you, it looks like the issue is somewhere around populating index and FK constraints, is there anything obviously different about this server in terms of constarints? In the meantime I'll ask the team if there's any obvious reason this might be the case. / comments
bstewart wrote: Unfortunately, the log doesn't reveal much other than how long each part of the comparison is taking: 13:03:01.683|Debug |PopulationLogger |5 |ProgressTask:Populating DB tes...
0 votes
Ah yes, ok. There are several suggested solutions to that issue posted here: https://forums.oracle.com/forums/thread ... ID=2217135 If the script is <50mb I'd probably try SQL Developer, else would any of the other solutions suit? Regards, Michael / comments
Ah yes, ok. There are several suggested solutions to that issue posted here:https://forums.oracle.com/forums/thread ... ID=2217135 If the script is <50mb I'd probably try SQL Developer, else would ...
0 votes
Hi Melissa, Once you have the script saved (it's just a .sql script) you could use your editor from the command line to run it, for example: http://serverfault.com/questions/87035/ ... and-prompt Would that work for you? Best regards, Michael / comments
Hi Melissa, Once you have the script saved (it's just a .sql script) you could use your editor from the command line to run it, for example:http://serverfault.com/questions/87035/ ... and-prompt Wo...
0 votes
Apologies for not updating this post sooner. We followed up by email and haven't heard back yet. Regarding the enquiries, if you have faced similar issues, it would really help if you could let us know the following: Q1. My biggest concern is whether it will work for syncing a local database with a remote database that runs on linux debian. My server does not allow remote connection and will not allow it either. So your software would need to use a remote php wrapper.. similar to how PHPMaker can connect to my remote database by pointing to a php file that sits on the server. Hopefully yours can also do this otherwise this is a deal-breaker.. so if anyone could confirm this I would appreciate it. A1. Our tools allow for connecting via an SSH tunnel, would that work for you? Else I think we're not going to be able to help. Q2. I immediately get a popup saying my trial is expired. A2. Apologies for the inconvenience here, please contact me for a trial extension (details below). Q3. Your software remoted there are available updates, even though I JUST got the (latest?) version from your trial download page. A3. This is odd and having looked into it I still can't work out how this has happened for you. We did have a moment around last week where our downloads were temporarily unavailable, but this was well before your post (and thus probably your download). The latest versions (and those on the website) should be 1.0.0.301 for MySQL Compare and 1.0.0.351 for MySQL Data Compare. Let us know if you don't have these currently (Help -> About within each tool should tell you). Best regards, Michael Christofides MySQL team USA: +1 866 997 0390 UK: +44 (0) 1223 438 739 michael.christofides@red-gate.com / comments
Apologies for not updating this post sooner. We followed up by email and haven't heard back yet. Regarding the enquiries, if you have faced similar issues, it would really help if you could let us...
0 votes