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

wont compare some columns

va2dosva2dos Posts: 2
edited November 15, 2011 10:32AM in MySQL Data Compare
Hi there, I have some column when i compare with MySqlCompare they show has identical, but when i try to sync the data, it refuse to compare some varchar field marked with a yellow (!) sign w/o any other indications

here's the Table creations script and a screen shot of mySqlCompare

CREATE TABLE `rabbids_sb`.`share_definition_message` (
`id` int(10) NOT NULL auto_increment,
`share_definition_id` int(10) NOT NULL DEFAULT 0,
`title` varchar(100) NOT NULL DEFAULT '0',
`description` varchar(100) NOT NULL DEFAULT '0',
`image` varchar(100) NOT NULL DEFAULT 'shareimage_test.png',
`link` varchar(100) NOT NULL DEFAULT 'StartPlaying_Link1',
PRIMARY KEY (`id`),
CONSTRAINT `fk_share_definition_message_def_id` FOREIGN KEY (`share_definition_id`) REFERENCES `rabbids_sb`.`share_definition` (`id`),
KEY `fk_share_definition_message_def_id`(`share_definition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

R9OHuBdS_qBBZVFStQo-hBXrGPMzQh26VmK1pyGcI6Q?feat=directlink[/img]

Comments

Sign In or Register to comment.