Solved

Copy data from one database to another using DataSets

Posted on 2008-10-02
5
911 Views
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?
0
Comment
Question by:JedNebula
  • 3
  • 2
5 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 22622741
ADO.NET Generic Copy Table Data Function
http://www.codeproject.com/KB/database/GenericCopyTableDataFcn.aspx


Moving data between MySQL and SQL Server (no code, just addressing some issues)
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1196733,00.html#
0
 
LVL 1

Author Comment

by:JedNebula
ID: 22624268
Thanks for the reply.

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

Expert Comment

by:Dhaest
ID: 22647429
>> non-matcing field names

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

Author Comment

by:JedNebula
ID: 22648536
Yes, but that's the bit I'm not sure how to do.
0
 
LVL 1

Accepted Solution

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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

810 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