(mysql.info) maxdb-mysql-interoperability

(mysql.info) maxdb-mysql-differences
 
 1.5.6 Interoperability Features Between MaxDB and MySQL
 -------------------------------------------------------
 
 MaxDB and MySQL are independent database management servers. The
 interoperation of the systems is possible in a way that the systems can
 exchange their data. To exchange data between MaxDB and MySQL, you can
 use the import and export tools of the systems or the MaxDB
 Synchronization Manager. The import and export tools can be used to
 transfer data in an infrequent, manual fashion. The MaxDB
 Synchronization Manager offers faster, automatic data transfer
 capabilities.
 
 The MaxDB Loader can be used to export data and object definitions. The
 Loader can export data using MaxDB internal, binary formats and text
 formats (CSV). Data exported from MaxDB in text formats can be imported
 into MySQL using the `mysqlimport' client program. To export MySQL
 data, you can use either `mysqldump' to create `INSERT' statements or
 `SELECT ... INTO OUTFILE' to create a text file (CSV). Use the MaxDB
 Loader to import the data files generated by MySQL.
 
 Object definitions can be exchanged between the systems using MaxDB
 Loader and the MySQL tool `mysqldump'. As the SQL dialects of both
 systems differ slightly and MaxDB has features currently not supported
 by MySQL like SQL constraints, we recommend to hand-tune the definition
 files. The `mysqldump' tool offers an option -compatible=maxdb to
 produce output that is compatible to MaxDB to make porting easier.
 
 The MaxDB Synchronization Manager is available as part of MaxDB 7.6.
 The Synchronization Manager supports creation of asynchronous
 replication scenarios between several MaxDB instances. However,
 interoperability features also are planned, so that the Synchronization
 Manager supports replication to and from a MySQL server.
 
 In the first release, the Synchronization Manager supports inserting
 data into MySQL. This means that initially only replication from MaxDB
 to MySQL is supported. In the course of 2005, exporting of data from a
 MySQL server to the Synchronization Manager will be added, thus adding
 support for MySQL to MaxDB replication scenarios.
Info Catalog
(mysql.info) maxdb-mysql-differences
(mysql.info) maxdb
(mysql.info) maxdb-links
automatically generated byinfo2html