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

Moving info from Access to MySql with C#

I am interested in moving certain tables from Access to MySql with C#.  I just got the SDK off the net and am very new with this.  Ideally, the information would be grabbed on an hourly basis while the access program is in use.  Any ideas/help would be greatly appreciated.
0
elbarro
Asked:
elbarro
3 Solutions
 
doryllisCommented:
You could try running through ODBC to connect to both systems and then just use SQL commands/datasets within the program to transfer the data.

This isn't the ideal situation but it is very flexible and I have used it somewhat successfully. If you ever move from access, or the file location changes you just point your ODBC connection to the new location. (No recompile required)

Are you looking to move the whole table or just the updated/changed records?
0
 
msdixonCommented:
here's a data provider for mysql. i've used it in development, but not in a production environment so i don't know how it'll hold up.
http://www.mysql.com/portal/software/item-282.html
0
 
AgariciCommented:
try loading the table you want to move in a DataSet through a (Ole/sql)DataAdapter bound to the access db and then, save that dataset through another dataadapter, bound to sql database

you can load tables into dataset using the 'fill' function of the dataadapter and save the dataset back in the database using 'update' fnc.
0
 
elbarroAuthor Commented:
doryllis, I would probabally just move the changed records.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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