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

Issues found in the first five minutes

kAlvarokAlvaro Posts: 13
edited October 14, 2010 5:30AM in MySQL Compare
This is roughly what I've just reported in the feedback form:

- Bottom panels highlight different database names as difference

- Does not handle default values in date columns, such as:
`fecha_alta` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

- It doesn't compare data yet it compares and changes AUTO_INCREMENT

- If there are foreign keys, it can completely mess the database:

CREATE TABLE `my_db`.`RG_TEMP_1672935009_0` ( ........) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_spanish_ci AUTO_INCREMENT=133;
/* SQL Error (1005): Can't create table 'infocap_infocap_demo.rg_temp_1672935009_0' (errno: 121) Duplicate key on write or update */
Álvaro G. Vicario - Burgos, Spain
Sign In or Register to comment.