Red Gate forums: MySQL Data Compare

RE: Does Data Compare support command line calls?

Michael Christofides — Thu, 21 Mar 2013 11:29:58 GMT

Hello.

You can call MySQL Data Compare from the command line, by running MDC.exe from the installation directory. You can get the documentation by running:

MDC /? /v

Whilst there isn't a success/failure output (I've added your support to our feature request MSDC-27), others have used the tool to generate the deployment script for the differences and saved that to a folder each time (success would be an empty script).

We'd be interested how you find the tool.

Does Data Compare support command line calls?

jjscott — Tue, 19 Mar 2013 18:40:15 GMT

I have real-time database replication enabled between two MySQL v5.5.29 databases and I need an automated method to determine if the db's are in sync. I would implement a nightly or weekly process to call the utility to verify success or failure.

Can I call the dbcompare utility from a script and parse a return code for success or failure? This would be the same as calling the native MySQL utility mysqldbcompare.exe. While I've used the latter, it's just too slow for pratical use.

Thanks

RE: tables that could not be compared

Michael Christofides — Wed, 09 Jan 2013 10:28:44 GMT

Thank you dknight. Yes, although the specific example is for our SQL Server tool, that's the issue. Hopefully all is well now, do let me know if not!

RE: tables that could not be compared

dknight — Mon, 07 Jan 2013 21:38:19 GMT

Found the answer in the KB:
http://www.red-gate.com/SupportCenter/Content/SQL_Data_Compare/knowledgebase/SDC_Objects_Not_Compared

RE: tables that could not be compared

dknight — Mon, 07 Jan 2013 21:27:25 GMT

I am having this same issue, and I'm running a registered version. In fact, the database is an exact copy (dumped the database, loaded to a new database in the same MySQL cluster, then diffed them just to be sure before modifying the new one). I would expect the databases to come up identical. Going to the MySQL command lines shows the contents of the tables as identical. I'm specifically using Data Compare.

RE: tables that could not be compared

Michael Christofides — Thu, 06 Dec 2012 09:56:05 GMT

The trial is fully functional, so it's not that.

Are the schemas of the tables that can't be compared identical? You could check this with the trial version of our other tool MySQL Compare

tables that could not be compared

MikeCaron — Wed, 05 Dec 2012 16:33:52 GMT

I just downloaded the trial and am getting 3 tables with differences, 14 tables that are identical, and 25 tables that could not be compared.

Are the tables that can not be compared a limitation of using the trial version?

My source is CentOS 6 x86_64, version 5.1.52 and my target is Windows 7, xampp install, version 5.5.8.

I switched the source and target and still had the same issue.

MySQL Data Compare - new minor version

Michael Christofides — Tue, 04 Sep 2012 10:18:37 GMT

New version available - 1.0.0.452

Minor bug fixes.

Please do continue to post feedback and questions here or send them to mysql@red-gate.com

RE: Modify deployment script capability

Michael Christofides — Fri, 16 Mar 2012 18:22:20 GMT

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

Modify deployment script capability

mniAP — Thu, 15 Mar 2012 17:29:06 GMT

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;

RE: MySQL Data Compare bug report

neil.anderson — Tue, 13 Mar 2012 17:09:39 GMT

Hi,

To get the table schema you can run the following command SHOW CREATE TABLE tbl_name in a tool such as MySQL workbench.

Neil

RE: MySQL Data Compare bug report

mmoore5553 — Tue, 13 Mar 2012 13:48:08 GMT

I am sorry but you can move this to the appropriate forum.

Yes i sent it to who the program sent it too. Also what do you mean on grabbing it ? How can i do that or the steps please.

I have tried other programs but they do not show me what is in the table so it is hard for me to tell if it is working or not.

RE: MySQL Data Compare bug report

neil.anderson — Tue, 13 Mar 2012 09:47:14 GMT

Hi mmoore5553,

Sorry you didn't get a reply to your bug report, did you send it to the mysql mailbox mysql@red-gate.com?

The data comparison tool attempts to bring the two databases inline so by default it will try to drop data that is only in the target. At the comparison grid you need to uncheck the rows that are only present in the target in order to have MySQL Data Compare leave those rows alone.

Can you post the schema of the table you are comparing (`xf_cz_group_member`) here? I suspect there are multiple keys on that table and selecting an alternate one to use during the comparison might help.

FYI there are forums just for the MySQL tools:

http://www.red-gate.com/MessageBoard/viewforum.php?f=119
http://www.red-gate.com/MessageBoard/viewforum.php?f=146

Regards,
Neil

MySQL Data Compare bug report

mmoore5553 — Tue, 13 Mar 2012 08:14:38 GMT

I have sent an email to your company but never heard and answer so trying here ... I need to get missing data out of the db. Also this is just going to migrate it over and keep the new stuff right ?

here is the error

Bug report generated at 3/13/2012 4:08:17 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;

INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (2, 1, 10, 1270390602);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (3, 1, 13, 1276891714);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (5, 1, 18, 1270390586);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (6, 1, 33, 1295320081);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (7, 1, 45, 1270390608);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (8, 1, 61, 1270390592);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (9, 1, 67, 1315961635);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (10, 1, 80, 1275877721);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (11, 1, 93, 1270434534);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (12, 1, 127, 1271096872);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (13, 1, 129, 1284475491);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (14, 1, 130, 1271725893);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (15, 1, 131, 1271725886);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (17, 1, 133, 1271733515);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (18, 1, 134, 1271734690);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (19, 1, 135, 1281463558);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (20, 1, 137, 1272912143);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (21, 1, 138, 1294025904);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (22, 1, 167, 1273456074);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (23, 1, 173, 1273592087);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (24, 1, 175, 1277839308);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (25, 1, 185, 1273717586);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (26, 1, 193, 1273851089);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (28, 1, 201, 1274283153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (29, 1, 222, 1276164038);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (30, 1, 223, 1275410055);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (32, 1, 225, 1275434240);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (33, 1, 229, 1275502322);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (34, 1, 230, 1275601546);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (35, 1, 231, 1275604153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (36, 1, 234, 1275620600);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (37, 1, 235, 1275675031);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (38, 1, 238, 1275706696);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (39, 1, 242, 1275706718);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (40, 1, 251, 1275706733);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (41, 1, 253, 1275756174);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (42, 1, 258, 1275756220);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (43, 1, 266, 1277219117);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (44, 1, 275, 1275756378);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (45, 1, 277, 1275756359);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (46, 1, 298, 1275869970);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (47, 1, 319, 1276860363);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (48, 1, 326, 1276309513);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (49, 1, 330, 1276508826);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (50, 1, 331, 1276481129);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (51, 1, 336, 1317673944);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (52, 1, 339, 1276539240);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (53, 1, 350, 1276794235);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (54, 1, 404, 1277407710);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (55, 1, 407, 1277425186);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (56, 1, 422, 1293906923);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (58, 1, 445, 1277764028);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (59, 1, 453, 1277920681);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (60, 1, 460, 1280264856);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (61, 1, 478, 1278819205);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (62, 1, 504, 1279652536);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (63, 1, 514, 1279926398);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (64, 1, 516, 1279984115);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (65, 1, 521, 1281452610);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (66, 1, 587, 1281553993);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (67, 1, 594, 1281720163);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (68, 1, 601, 1308571928);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (69, 1, 625, 1282511747);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (70, 1, 629, 1282603510);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (71, 1, 637, 1282879660);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (72, 1, 672, 1283792720);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (73, 1, 702, 1283916609);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (74, 1, 713, 1283916332);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (75, 1, 821, 1284487582);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (76, 1, 868, 1285524888);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (77, 1, 875, 1285524896);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (78, 1, 917, 1285616540);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (79, 1, 926, 1285779315);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (80, 1, 936, 1285779330);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (81, 1, 966, 1285959326);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (82, 1, 1018, 1286665021);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (83, 1, 1021, 1286587962);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (84, 1, 1025, 1308432961);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (85, 1, 1041, 1286903634);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (86, 1, 1113, 1287520733);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (87, 1, 1114, 1303831701);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (88, 1, 1123, 1287607177);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (89, 1, 1141, 1293830681);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (90, 1, 1152, 1287848834);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (91, 1, 1244, 1288749989);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (92, 1, 1263, 1289248129);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (93, 1, 1292, 1289248081);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (94, 1, 1339, 1289248078);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (95, 1, 1489, 1291575248);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (96, 1, 1501, 1291005264);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (97, 1, 1526, 1291508183);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (98, 1, 1543, 1291508252);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (99, 1, 1591, 1292200574);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (101, 1, 1712, 1294285913);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (102, 1, 1721, 1294862593);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (103, 1, 1732, 1294862601);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (104, 1, 1746, 1295145779);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (105, 1, 1750, 1302422729);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (106, 1, 1758, 1295324140);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (107, 1, 1837, 1298341274);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (108, 1, 1847, 1298341276);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (109, 1, 1853, 1298341275);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (110, 1, 2015, 1300922746);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (111, 1, 2288, 1303870470);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (112, 1, 2385, 1305078896);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (113, 1, 2392, 1305326503);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (114, 1, 2568, 1317318235);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (115, 1, 2658, 1316193991);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (116, 1, 2774, 1309743911);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (117, 1, 2776, 1310248665);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (118, 1, 2777, 1319558492);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (120, 1, 2822, 1310441948);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (121, 1, 2823, 1310537924);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (122, 1, 2824, 1315783907);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (123, 1, 2856, 1316268718);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (125, 1, 2879, 1310694521);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (126, 1, 2893, 1313346153);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (127, 1, 2943, 1312149386);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (128, 1, 2996, 1319404101);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (129, 1, 3113, 1316617159);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (130, 1, 3120, 1313449146);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (131, 1, 3162, 1313960386);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (132, 1, 3202, 1314637482);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (133, 1, 3203, 1315442400);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (134, 1, 3265, 1324307422);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (135, 1, 3267, 1315783907);
INSERT INTO `barefoot_newsite`.`xf_cz_group_member` VALUES (136, 1, 3305, 1315755376);
---> Duplicate entry '1-175' for key 'ukey'
--- End of inner exception stack trace ---
at #2jmb.#1jmb.#um()
at #5jmb.#4jmb.#kFc.#zmmb()
at RedGate.Shared.Controls.ProgressDialogEx.e()

RE: Point data type bug

Michael Christofides — Fri, 09 Mar 2012 17:14:28 GMT

Just an update - this conversation continued via email - we hope to have a fix out around the end of March/beginning of April

Please continue to report any issues you have via this forum or by email: mysql@red-gate.com