Copy data from one database to another

  • Thread starter Thread starter sijank
  • Start date Start date
S

sijank

I m doing a project where i have to transfer data from one database(in
..MDB) to another database ( say.. . mysql). I know we can read the MDB
file and .. prepare SQL and .. run that in mySQL..or some other way..
making intemediate file...

I would like to know is there any better way... directly copying..?

Sijan Khadka
(cZn)
 
Create two data adapters, one OleDb for the Access db, one for MySql.
configure both of them. Fill a dataset with the Access one. Set
AcceptChangesDuringFill to false before filling. Call update on the second
adapter passing in the *same* dataset as the parameter. Enjoy
 
Back
Top