Re: Needed: An Efficient, reliable and smart way to copy data from one DB to another

Ted Byers wrote on 23.11.2005 06:20:
Ok, I have a prototype running, or I should say crawling, to copy data from an MS Access database over to an MySQL database. I'd already set up the tables and indeces, and was using a Java program to select all of the contents from each table in the Access DB and insert each row from the resulset into the MySQL. The largest table has about 7700 rows and a couple

Must be something with the network. I have a program that does essentially the same, and I can copy 10.000 records in about 30 seconds from PostgreSQL (8.1) to MySQL (5.0) both located on the same machine.

As I don't think my program does anything magic in terms of performance, I'd suspect that you have a network issue here.

Another thing to check is maybe the indexes you have defined on the target table. Maybe they are slowing down inserts. Try to drop them before copying the data, and re-create them afterwards.

Regards
Thomas
.

Relevant Pages

  • Access conversion to SQL
    ... I have an application that currently connects to an Access database, ... customers are asking for a MySql and MsSql server back end database. ... MySql handles True and False values through the bit field without any ... It also gives me the problem of setting controls true/false value by ...
    (microsoft.public.access.conversion)
  • Interesting ODBC problem
    ... I have just converted a guestbook to use an Access database rather than ... MySQL via odbc and have come across an unusual problem. ...
    (comp.lang.php)
  • Re: Pocket Access - Sync to Linked Table?
    ... syncronizes a Pocket Access database with my Access ... I can then maintain my DB within Access and syncronize the PDA ... Recently I've re-created my tables in MySQL, set up ODBC connections to them ... Pocket Access database through ActiveSync anymore because the linked tables ...
    (microsoft.public.pocketpc.activesync)
  • trouble with SQL syntax
    ... I'm having some trouble getting a search in an access database to work ... Model between StartYr and EndYr.On the form I have a combo named ... Dim mySQL As String ... the EndYr entries are "later" so as a result the StartYr and EndYr ...
    (microsoft.public.vb.general.discussion)
  • Problems accessing a MySQL database using an Access linked table
    ... between MySQL and another database, I've created an Access database ... application - classic ASP works fine but .NET gives me... ... If you are not the intended recipient please notify the sender that you have ...
    (microsoft.public.dotnet.framework.aspnet)