Generate Schema Script - Problem with FEDERATED ENGINE

[thomas_w]

I found some problem with "Generated Schema Script" (using "Devart Default"). I create this table using FEDERATED ENGINE.

Code: Select all

CREATE TABLE geodaten_remote(
  geodaten_id INT(11) NOT NULL,
  latitude INT(10) UNSIGNED NOT NULL,
  longitude INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (geodaten_id)
) ENGINE = FEDERATED
CONNECTION = 'mysql://user:password@localhost:3307/sample/geodaten';

Using Generate Schema Script I get this

Code: Select all

=========== Generate Schema Script =======================================
-- Script was generated by Devart dbForge Studio for MySQL, Version 5.0.28.0
-- Product home page: http://www.devart.com/dbforge/mysql/studio
-- Script date 22.04.2011 15:39:35
-- Server version: 5.6.2-m5
-- Client version: 4.1

USE sample;

CREATE TABLE geodaten_remote(
  geodaten_id INT(11) NOT NULL,
  latitude INT(10) UNSIGNED NOT NULL,
  longitude INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (geodaten_id)
)
ENGINE = FEDERATED
AVG_ROW_LENGTH = 35
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

CONNECTION Informations are lost. Any hint?

with kind regards,
Thomas

[.jp]

Unfortunately, FEDERATED ENGINE isn't supported by dbForge Studio for MySQL, v5.0.
Can you kindly log your request on dbForge's uservoice: http://devart.uservoice.com/forums/7729 ... -for-mysql

[.jp]

-- Server version: 5.6.2-m5

By the way, MySQL 5.6.x isn't supported by our tool either.

[thomas_w]

-- Server version: 5.6.2-m5

By the way, MySQL 5.6.x
isn't supported by our tool either.

hm, I get the same problem using MySQL v.5.5.9.

Why did dbForge for MySQL not doing something like this?

Code: Select all

mysql> show create table geodaten_remote;
+-----------------+------------------------------------------------------------------+
| Table           | Create Table                                                                                                               |
+-----------------+------------------------------------------------------------------+
| geodaten_remote | CREATE TABLE `geodaten_remote` (
  `geodaten_id` int(11) NOT NULL,
  `latitude` int(10) unsigned NOT NULL,
  `longitude` int(10) unsigned NOT NULL,
  PRIMARY KEY (`geodaten_id`)
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user:passord@localhost:3307/sample/geodaten' |
+-----------------+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

It seems to be easy.

with kind regards,
Thomas

[.jp]

It seems to be easy.

If we support FEDERATED engine in "Generate Schema Script", we will also have to support it in other functionality: Visual Table Editor, Database Projects, Database Diagram, Database Backup/Restore, Schema Compare, and so on. This is quite a lot to do.
I've added a change request, but I haven't got any definite timeframe when it is done.

[.jp]

I have also added "federated engine support" feature on product's uservoice.

[thomas_w]

Thanks!