Solved

Moving info from Access to MySql with C#

Posted on 2003-10-29
4
245 Views
Last Modified: 2010-04-16
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
Comment
Question by:elbarro
[X]
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
4 Comments
 
LVL 2

Assisted Solution

by:doryllis
doryllis earned 83 total points
ID: 9646017
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
 
LVL 9

Accepted Solution

by:
msdixon earned 83 total points
ID: 9646332
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
 
LVL 11

Assisted Solution

by:Agarici
Agarici earned 84 total points
ID: 9650842
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
 

Author Comment

by:elbarro
ID: 9652066
doryllis, I would probabally just move the changed records.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

617 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