mysql to mssql

i have dumped a mysql database to my my documents folder on my server, how can i convert this to a mssql database.

the database came from a site that was in php and of course using mysql, the database has all the users logon information and other information in there personal profile.

i would like to convert this to a mssql database and connect it to the new site i am doing in .net/C#

I don't think there is any conversion tool to do that.|||

You have to use mySQL ODBC data source and import data from this source to SQL server, you can use SSIS package. Another solution is to do it inside your C# code you can have two connections and copy data from first (MYSQL) to second (MSSQL).

SSIS package will be faster.

And after that, or better before you have to create database structure on MS SQL server. but remember that MYSQL and MS SQL are not compatible.