Re: transfering only tables not databases
On the Manual Editing page (after the migration step) select the filter to show all objects. Then select the schema (should be the first row in the Migrated Object list and click [Advanced >>]. Then check the Comment Out checkbox.
In the latest 1.0.21 release existing schemata are not dropped anymore (if you do not activate it on the Advanced Object Mapping page) so it should be a non issue from now on, anyway, because of the IF NOT EXISTS syntax:
CREATE DATABASE IF NOT EXISTS `Nordwind`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Subject
Written By
Posted
November 29, 2005 07:29PM
December 08, 2005 04:07PM
December 08, 2005 06:41PM
Re: transfering only tables not databases
December 12, 2005 08:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.