Structure Synchronization Tool – V4.07

[jdrago]

Hi.

I am using SQLyog to sync up 2 databases.

I start by using the “Structure Synchronization Tool”, selecting the databases to compare, and click “Compare Now”.

Several tables show up in blue on both sides, and I select the tables on the left I want changed on the right.

I select “Sync (Clipboard)”

Some tables' “alter table” statements appear in my clipboard, but usually only one, and then several blank statements after that.

For example:

Code:

/* Alter table in Second database */
alter table `db_template`.`order_items`,
drop column `parent_id`,
drop column `order_item_price_each`,
drop column `order_item_recurring`;

/* Alter table in Second database */
alter table `db_template`.`orders`;

/* Alter table in Second database */
alter table `db_template`.`schedule_items`;

/* Alter table in Second database */
alter table `db_template`.`wflow_definition_state_actions`;

/* Alter table in Second database */
alter table `db_template`.`wflow_definition_states`;

/* Alter table in Second database */
alter table `db_template`.`wflow_instances`;

Each time I run the “Structure Synchronization Tool”, one more table has actual commands in its “alter table” statement, but there are always others with blank commands.

This feature was the entire reason why we bought SQLyog Enterprise. When can we expect a fix for this feature?

[peterlaursen]

I'll do some research on that.

In the meantime please answer:

1) MySQL server versions ?

2) SQLyog version ?

3) Conection types (direct/HTTP/SSH) ?

[peterlaursen]

I can't reproduce it. This is an example from struct-sync across MySQL-versions 4.0 and 5.0 using HTTP-tunneling with 4.0

Code:

/* Drop in Second database */
drop table `jazcyk_test`.`Important information`;

/* Drop in Second database */
drop table `jazcyk_test`.`mp3_filer_copy`;

/* Alter table in Second database */
alter table `jazcyk_test`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL ;

/* Create table in Second database */
create table `jazcyk_test`.`whertogo` (
`Id` int(10) unsigned NULL   ,
`goname` varchar(60) NULL   ,
`towncity` varchar(50) NULL   ,
`type` varchar(50) NULL   ,
PRIMARY KEY (`Id`) ,
KEY `citieswhertogo` (`towncity`) ,
KEY `townix` (`towncity`)
)Type=InnoDB;

[jdrago]

Hi.

MySQL Version = Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

SQLyog Version = 4.07

Using direct connections.

Table types are all MyISAM.

Something else to note – we are syncing up over 200 tables' structure from one DB to another.

[peterlaursen]

We need more info to get further!

But honestly I don't know where to start.

Probably some sample data are required. If you don't want to attach them here, I am sure that you can mail them confidently to Ritesh in the morning.

Could it be a user privilege problem? If you don't already try ROOT (or the user with most priviliges available) on both servers!

Quote:

This feature was the entire reason why we bought SQLyog Enterprise. When can we expect a fix for this feature?

My humble opinion: don't be so sure that SQLyog needs a fix here. It could be your configuration that needs a fix! <_<

[peterlaursen]

Quote:

MySQL Version = Ver 14.7 Distrib 4.1.8, for pc-linux (i686)

SQLyog Version = 4.07

Using direct connections.

What is “MySQL Version = Ver 14.7 …” ?

I know what MySQL 4.1.8 is. That MySQL was “built-in” the Linux-distribution I guess ??

I understand that you purchased SQLyog recently, so I can't know how much you have been using it for other purposes. But are there any other problems experienced with the porgram ? If you click on a table in Object Browser and select the OBJECTS-tab will the table definition then display correctly ?

Are you trying to sync all 200 tables “in one round”. If yes, will it solve problems to have a smaller number of tables ?

[peterlaursen]

could be a crazy idea ….

but what happens if you copy to a file and not to clipboard ?

[jdrago]

I'm sorry about jumping to conclusions about assuming the software is buggy.

When I select “Sync (File)” the same thing happens – only the first table has actual alter statements.

[jdrago]

I will create a simple test and see if I can duplicate it on a smaller scale – BRB

[peterlaursen]

just for completenes.

Here you have a case with two tables and several changes within each

Code:

/* Alter table in Second database */
alter table `test4`.`roles`,
change `RoleID` `RoleID` int(11) NULL  auto_increment,
change `RoleDescription` `RoleDescription` varchar(50) NULL  ,
change `CostumeDescription` `CostumeDescription` varchar(50) NULL  ,
change `CompanyID` `CompanyID` int(11) NULL  ,
change `ProjectID` `ProjectID` int(11) NULL  ,
change `SectionID` `SectionID` int(11) NULL;

/* Alter table in Second database */
alter table `test4`.`whertogo`,
change `Id` `Id` int(10) unsigned NULL  ,
change `goname` `goname` varchar(60) NULL  ,
change `towncity` `towncity` varchar(50) NULL  ,
change `type` `type` varchar(50) NULL;

[Ritesh]

@jdrago

Just attach or mail me the sturcture dump of both the databases. To test structure sync, I dont require your data.

[jdrago]

Unfortunately I cannot share the structure of the database.

However, I did create a test database with over 200 tables, and have had no problems making the Structure Sync tool work on that database.

I've tried creating new tables, deleting them, adding/changing/removing columns — everything, and I can't duplicate the problem I was having on the actual database. Even the database I was having problems with works now. 😮

If I can figure out why it wasn't working before, I will post here right away.

Thanks for all your help!

[GreenAlien]

jdrago wrote on Aug 3 2005, 03:49 PM:

Unfortunately I cannot share the structure of the database.

However, I did create a test database with over 200 tables, and have had no problems making the Structure Sync tool work on that database.

I've tried creating new tables, deleting them, adding/changing/removing columns — everything, and I can't duplicate the problem I was having on the actual database.  Even the database I was having problems with works now. 😮

If I can figure out why it wasn't working before, I will post here right away.

Thanks for all your help!

[post=”6748″]<{POST_SNAPBACK}>[/post]

Well I've just experienced this issue too, and my database (early stages) only has four tables and a handful of fields in each.

I'm using v4.1 Enterprise (Trial).

I started a thread before I spotted this one, here it is:

http://www.webyog.com/forums/index.php?showtopic=1627

Rgds, Ant

ps: @Ritesh I'm happy to email you my database (before and after) so long as you dont share it with anyone else. Let me know if you want it.

[Author]

Posts