Table Record Copying from different Database, MYSQL, w/ DisconnectedRS.UPDATEBATCH

[sesproul]

Hello,

Here is the scenerio.

I have an enterprise MYSQL that all the main data for a basic ERP. But I also have a Development MYSQL that I am using to prep the DATA with, and I use this local Development MYSQL (it runs on a virtual instance on my laptop) whe I am not connected to the Enterprise DB Server.

So Connecting to any of the DB is working fine, but I am in a situation where I want to move the Data from one DB server to the other, and I was wondering if I could do it with an other than brute force method of reading data from one connection, and inserting to another connection. (Basically building SQL insert statements as the first Recordset is iterated.)

Both database have identical Structures. So I thougt about using disconnected Recordsets, and the UPDATEBATCH method.

Using some code I downloaded, I rewrote it to hook to my two DB's and it connects, loads records, and drops the first connection perfectly, and then reconnects to the new DB fine , buy won't update all the records from the first DB into the second DB.

I don't want to wast too much time with this, but I will have 10-15 tables that may need to be updated this way.(I am also looking into a local ACCESS db with identical structure (with COUNTER instead of auto_INCREMENT fields ID Columns) that could frequently be used to work offline, that may need the data updated from time to time.)


If anyone has any experience with this - I'd love to hear about it.


thanks


Steve

[sesproul]

No Responses, so I just bit the Bullet and wrote a routine to open a Recordset against the first DB, and then build a INSERT statment into the second.

LEARNED an interesting thing about MYSQL.

the LINUX version is case sensitive, and the windows version is Case insensitive.

So I changed all tables to be consistent with Lower case names. Now everything works fine.


Steve