• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 922
  • Last Modified:

Copy data from one database to another using DataSets

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
JedNebula
Asked:
JedNebula
  • 3
  • 2
1 Solution
 
DhaestCommented:
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
 
JedNebulaAuthor Commented:
Thanks for the reply.

Do you have any solution for the non-matcing field names?
0
 
DhaestCommented:
>> non-matcing field names

I don't think that there is a proper solution. You'll need to configure the right mappings
0
 
JedNebulaAuthor Commented:
Yes, but that's the bit I'm not sure how to do.
0
 
JedNebulaAuthor Commented:
I wrote my own class to deal with it in the end.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now