Convert MySQL database to MS SQL 2005

Greetings:

What is a recommended method of migrating a MySQL database to MS Sql 2005?

I have a phpMyAdmin-generated .sql file that looks like this:

[excerpt of create table scripts]
CREATE TABLE _inventory (
productId bigint(20) NOT NULL auto_increment,
StockNo varchar(40) default NULL,
Title varchar(255) default NULL,

[except of data insertion]
INSERT INTO _inventory VALUES (1, 'stockno', 'titlesw', 'descsd', 'EAST AFRICA') ....

I also still have access to the original source database.

I would use SSIS but according to another post, discount asp does not support it.

Thanks ,John

 

John,

There's really no standard or preferred method that you can convert MySQL to a SQL 2005 database. Probably the best bet is to copy your MySQL database from our server to your local machine. Then migrate your MySQL database to a local SQL Express 2005 database. SQL 2005 Express is also a free product you can download from Microsoft.

This way you minimize any potential problems to your production server. Once you locally migrated MySQL to SQL 2005 then you can order the SQL 2005 addon and use the SQL Management Tool to upload