How To: dBase Database -->> Interbase?
Andrew Fittro
that can make this task easier? Right now, all I can figure out
is to write the blasted .Dbf to a text file, create an 'external'
interbase table with everything just right, create a 'real'
interbase table, read the text into the external, read the
external into the real,etc..etc...etc.. Stink! This is a PAIN!
I have a whole MESS of these things I wanna convert. Not to mention
having to redo indexes manually.
Someone please tell me there is a easier/sane method. Pretty please.
==========================================================
Andrew Fittro - Computer Consultant - ARK Systems Software
afi...@perpetual.com http://www.perpetual.com/
"Believe on the Lord Jesus Christ and thou shalt be saved"
Steve Koterski
: Is there a component, application, or code snippet somewhere
: that can make this task easier? Right now, all I can figure out
: is to write the blasted .Dbf to a text file, create an 'external'
: interbase table with everything just right, create a 'real'
: interbase table, read the text into the external, read the
: external into the real,etc..etc...etc.. Stink! This is a PAIN!
: I have a whole MESS of these things I wanna convert. Not to mention
: having to redo indexes manually.
: Someone please tell me there is a easier/sane method. Pretty please.
On the interactive level, you could use the Database Desktop utility to
copy from one table to another. The source and destination table types do
not have to be the same. Use the menu option Utilities|Copy.
In an application, you can migrate data from one table to another, incl-
uding across different table types, using the TBatchMove component. The
TBatchMove component is described in the section "Using TBatchMove" on
page 89 of the Database Application Developer's Guide. Essentially, you
provide a TTable or TQuery as the source table and a TTable as the
destination table. Each of the source and destination TTable/TQuery
components would be set up to point to the appropriate alias (or dire-
ctory) and table name. The destination does not have to pre-exist as
long as the Mode property of the TBatchMove component is set to batCopy,
the destination file will be created if it does not exist or overwritten
if it does.
--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Steve Koterski _/ The opinions expressed here are _/
_/ kote...@borland.com _/ exclusively my own _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Al Grabauskas
>Is there a component, application, or code snippet somewhere
>that can make this task easier? Right now, all I can figure out
>is to write the blasted .Dbf to a text file, create an 'external'
>interbase table with everything just right, create a 'real'
>interbase table, read the text into the external, read the
>external into the real,etc..etc...etc.. Stink! This is a PAIN!
>I have a whole MESS of these things I wanna convert. Not to mention
>having to redo indexes manually.
>Someone please tell me there is a easier/sane method. Pretty please.
>==========================================================
>Andrew Fittro - Computer Consultant - ARK Systems Software
>afi...@perpetual.com http://www.perpetual.com/
>"Believe on the Lord Jesus Christ and thou shalt be saved"
look up the BatchMove component in the help. don't know much about it
yet, but it sounds like what you may be lloking for. an excerpt from
the overview follows:
Overview of Batch Operations
See Also
Batch operations are operations that you perform with the TBatchMove
component on groups of records, or datasets.
The primary uses of TBatchMove are:
Downloading data from a server to a local data source for analysis or
other operations
Upsizing a database from a desktop data source to a server
TBatchMove is powerful because it can create tables on the destination
that correspond to source tables, automatically mapping the column
names and data types. If you move data between different types of
tables, Delphi maps the data types as described in Data Type
Translations in Batch Operations.
hope this helps.
Nik Hughes
>From: afi...@perpetual.com (Andrew Fittro)
>Subject: How To: dBase Database -->> Interbase?
>Date: Wed, 26 Jul 95 00:03:38 GMT
>Is there a component, application, or code snippet somewhere
>that can make this task easier? Right now, all I can figure out
>is to write the blasted .Dbf to a text file, create an 'external'
>interbase table with everything just right, create a 'real'
>interbase table, read the text into the external, read the
>external into the real,etc..etc...etc.. Stink! This is a PAIN!
>I have a whole MESS of these things I wanna convert. Not to mention
>having to redo indexes manually.
>Someone please tell me there is a easier/sane method. Pretty please.
>==========================================================
>Andrew Fittro - Computer Consultant - ARK Systems Software
>afi...@perpetual.com http://www.perpetual.com/
>"Believe on the Lord Jesus Christ and thou shalt be saved"
If there is a close match between the structure of your old database and your
new database, you can use the TBatchMove component directly on two TTable
Compnents linked to your datafiles. If you need to do a fair amount of
preprocessing, you can use can use a TQuery component as your Source and use
SQL to perform the preprocessing. In either case, the BatchMove is a good
place to start.
+- Nik Hughes (aka Troll) -------------+
| Social & Scientific Systems |
| NHu...@sss.niaid.nih.gov |
+--------------------------------------+