hi all,
i am moving data from MS access(actually from SQL server) to mySQl using VB.

i have to access like 10- 12 tables in MS access and insert into 6-7 tables in mysql. i created index/primary key from where i am searching for records etc..

but it is still taking me an hour to insert 2000 records and like i have have 250 k records to be moved from one DB to another. at this rate i will never be able to finish the migration. so can some body please give pointers in this aspect.

my co-worker take on this is, VB handling of objects is very poor and hence the slowness. ? is it so?

thank you
lucy

You can try a query that selects the necessary data from linked SQL Server tables and appends it to linked MySQL tables. If this method proves too slow, you can export in .csv format the SQL Server data then import the .csv data and append to the MySQL table.