Move Data From MySQL 5.1 to SQL-2005

[The-One]

Hi

I really hope someone could please assist me in the following.
I would like to Migrate data from MYSQL 5.1 to SQL-2005 but having a very difficult time in doing it, is there much easier way to accomplish my task?
The server Runs Mysql-5.1 and Sql-Server 2005 so there is not networking involved; I have installed the Mysql OBDC drivers

I would appreciate if someone could point me in the right direction

 

[Kyubi_ZA]

Export and Import CSV ?

 

[Kloon]

Try using the SQL Server Import and Export wizard

 

[The-One]

I am dealing with over 24mil records so export wont work and Sql-2005 does not allow to imort from MYSQL

 

[Nod]

Why are you doing the migration, if I may ask?
What do MS-SQL offer that you can't do in MySQL or even Postgress?

 

[The-One]

They standardising it all to MS-Sql so dont have much of a choice but to move it, trust me if i had my way i would leave it

 

[Fuzzbox]

DTS in sql2005 should be able to sort you out

 

[Nod]

They standardising it all to MS-Sql so dont have much of a choice but to move it, trust me if i had my way i would leave it

All the eggs in one basket? I prefer a variety of technologies on different platforms. Sometimes expensive, but the changes of then all catching the same bug is minimal.