Re: How to export to comma delimited file from Oracle8?

This topic has generated many answers. Here is one more: For push and pull between Oracle, Textfiles, Excelfiles SQL Server, Sybase you can use a tool called SQLMover
A flexible tool for the DB-knowledgeable with full error handling capabilities that allows you to replicate and convert automatically between any ODBC compliant datasources.
SQLMover can be installed on a NT Server or a WS (or Windows 95) and initiated manually or automatically. It has transaction support if supported
by the destination DB.
SQLMover uses standard, simple or complex SQL SELECT statement in the source end and INSERT, UPDATE, INSERT then UPDATE, UPDATE the INSERT or DELETE statement towards the destination database table.

Data conversion and cleaning can be performed by using the SQL conversion or string functions in the SELECT statement towards the source DB, by using

the built in Format Mask functions or by using triggers in the destination database. To evaluate until Oct.31 you can download from www.sqlmover.com (follow the
download buttons) and use the evaluation key OSHKSHTD. The key allows you to transfer max. 500 rows per transfer/replication task and max. 5 tasks can be defined.  

Depending on your business rules you may choose from a variety of replication design models.

For DW purposes you can choose to let SQLMover aggregate your data by using SELECT -GROUP BY. For more ideas info about oneor  two way replication setups please use the support form att www.sqlmover.com for more info.

SQLMover processes can be configured to work in parallell. Peder Holst,
pederh_at_elektrosoft.se Received on Tue Sep 30 1997 - 00:00:00 CEST