|
| Transfering data from one database to another |   
|
|---|
| Data migration across ADO/ODBC connections | Product:
Delphi 5.x (or higher) | Category:
DB-General | Skill Level:
 | Scoring:  | Last Update:
04/15/2002 | Search Keys:
delphi delphi3000 article borland vcl code-snippet databases proprietary formats transfer data migration ADO ODBC connections transfer | Times Scored:
6 | Visits:
3561 | Uploader: Gabhan O
Company: | Reference: N/A | | Component Download: http://www.gabhan.com/GabhansDataPumpSetup.exe | | | Question/Problem/Abstract:
I work with various databases from DBase, Interbase, SQL Server and Oracle to old proprietary formats and sometimes even csv or fixed length field files. It always proved a challenge to reliably transfer data from these, to our desired database server. | Answer:
I wrote a little Delphi app to get data from one ADO Connection (or ODBC) to another with support for mapping and default data in fields. It supports auto committing and auto string trimming and auto null values where source contains blank strings. It also has support for showing source data and allowing the user to rollback to before the transfer started, or continuing and skipping the rows with errors. Can also allow a series of tables to be queued to transfer and saving and loading of mappings for frequent similar transfer of data.
Basically 2 ADOTables with a couple of TLists to store mappings and the following code to transfer the data
ADOToTable.FieldByName(ToField).AsVariant := ADOFromTable.FieldByName(FromField).AsVariant;
Full source is avaliable on request.
It is surprising how often this little tool has been put to use in our office...at least on a weekly basis...
Any comments to gabhan@input.ie
|
|
|
| |
Sign up to consume product discounts for Bronze memberships !
|
|
| |
Community Ad of
E. Irigoyen |
|
| |
|
|
|
Sign Up
