Eric,
A quick and standardised solution for you would be to use a transfer and
replication product called SQLMover. Just point your dBase ODBC driver to
your dBase database files and your Intersolv Oracle ODBC driver to the
Oracle database and you are on your way. The dBase driver is included in
the MS ODBC desktop driver set and can be downloaded together with SQLMover
from http://www.sqlmover.com. The Oracle Intersolv ODBC driver is included
in Intersolvs DataDirect package and can be downloaded from
http://www.intersolv.com. SQLMover migrates/converts/replicates between all
ODBC compliant databases. To evaluate SQLMover this month use the key
1JHHYDOHG.
SQLMover uses a simple or complex SELECT statement towards your datasource
and a INSERT, UPDATE, INSERT and UPDATE or DELETE statement towards the
destination table. SQLMover has a built in schedule engine and provides
extensive error logging capabilities. If you want to change datatypes when
transferring/replicating SQLMover provides implicit conversion, if you want
to you can also apply conversion statement in your SELECT query (or string
functions for concatenation and splits, mathematical and date/time
functions) or by using the built in format mask wizard. For very complex
cleaning and conversion operations you will always have the choice of
introducing an intermediate desktop or low cost DB like personal Oracle or
SQL Server workstation. Also - if you are into Data Warehousing - check the
News page at http://www.sqlmover.com.
Regards,
Peder Holst
Received on Wed Nov 26 1997 - 00:00:00 CST
