Re: destroyed information_schema?
Chagh,
the information_schema in MySQL is a "virutal" schema, it cannot be dropped or destroyed and you cannot create your own tables there or overwrite data. So no worries here.
The problem with the Migration Toolkit is, that you cannot select the catalog (=MSSQL Database) that should be migrated at the moment. The default catalog of the user account you connect to will be chosen. This has already been addressed and will be in the next release that will be out later this week.
As a workaround you can press the [Advanced >>] button on the conection and check the box [X] Enter JDBC connection string manually, and enter a string like this
jdbc:jtds:sqlserver://localhost:1433/Northwind;user=mike;password=mypassword
Notice that after the port number 1433 you state the database you want to connect to. In this case it is Northwind.
As I said before, this is just a workaround till the next release is out.
On the schema selection page you normally select the dbo schema to migrate.
Mike
Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
Subject
Written By
Posted
Re: destroyed information_schema?
May 31, 2005 12:40PM
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.