we are looking to migrate our database from the default mysql to a dedcated MSSQL 2005 environment,

i am able to do a mysql dump of the database but am unable to figur out a way of migrating the databases.

has anyone done this? or is anyone able to shed some light on it?