Issues found in the first five minutes

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

Issues found in the first five minutes

Postby kAlvaro » Thu Oct 14, 2010 10:30 am

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
kAlvaro
 
Posts: 9
Joined: Mon Jan 18, 2010 11:33 am
Location: Spain

Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 0 guests