Copy data from one database to another using DataSets
Posted on 2008-10-02
I am looking for the most efficient and easy way to copy data from a MS SQL Server database into a mySQL database.
I am using VB.NET (VS 2008) and currently attempting it using DataSets, DataAdapters and Connection objects for the right type of database, but I'm getting a bit stuck.
Just to throw one more spanner in the works, the column and table names are different in both databases so I'll need to do some kind of mapping I guess.
Could someone point me towards or indicate a sample of doing this?