SQL Toolkit Copy Records db1->db2

[Diverdke]

Occasionally, I want to archive records from 1 database to another.  No change in tables or fields, just copy.

Basically, I

Create Record (db2)

Fetch Next until EOF (db1)

PutRecord (db2)

This works, but it is incredibly slow.  Any suggestions would be appreciated.  I will post code later today.

Thanks in advance, Dave

[Haagen-Dazs]

Hi Diverdke,

From what you have described this seems like the most efficient way to move that data. Do the records contain a lot of data? Or does the database have any scheme to keep records in a certain order? There are many factors that may influence performance and those could be hardware or software related. As I said previously the steps you are taking to move the record, in my mind, is the most efficient and straightforward way.