How to transfer data from MY SQL To MS SQL Server

[nikhil.desai1]

Hi,

I have one Database Name DB_Emplolyee in Sql Server 2005 on particular server named ABC. It has only one Table name Employee
The Structure of table is as follows

Emp_id int Not Null
FName varchar(20) Null
MName varchar(20) Null
LName varchar(20) Null
DeptID int Not Null
DepTName varchar(20) Not Null

The table is empty.

Now there is same database DB_Employee in MY SQL on a server name XYZ. It has same Table name Employee. The structure of table is also same.
The table contains 20 records. Now I want to transfer this 20 records into database DB_Employee of MS SQL Server. This transfer should be online.
How can I do this . Please give me some solution.

Regards,
Nikhil

[rmiao]

Can try with linked server, ssis package, data import wizard, ...