Re: destroyed information_schema?
Posted by: Michael G. Zinner
Date: May 31, 2005 12:40PM

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

Options: ReplyQuote


Subject
Written By
Posted
May 31, 2005 12:10AM
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.