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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

730 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