Copy data from one database to another using DataSets

Posted on 2008-10-02
Last Modified: 2012-05-05
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?
Question by:JedNebula
  • 3
  • 2
LVL 53

Expert Comment

ID: 22622741
ADO.NET Generic Copy Table Data Function

Moving data between MySQL and SQL Server (no code, just addressing some issues),289483,sid87_gci1196733,00.html#

Author Comment

ID: 22624268
Thanks for the reply.

Do you have any solution for the non-matcing field names?
LVL 53

Expert Comment

ID: 22647429
>> non-matcing field names

I don't think that there is a proper solution. You'll need to configure the right mappings

Author Comment

ID: 22648536
Yes, but that's the bit I'm not sure how to do.

Accepted Solution

JedNebula earned 0 total points
ID: 22738735
I wrote my own class to deal with it in the end.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now