data transfer from oracle 7.3 -> MS Sql Svr 6.5 (nightly 'snapshots')

Is there a clean way to keep a sql server database synched with an oracle database? We have data in an oracle database that needs to be mirrored in SQL Server somehow, and doing nightly data transfers is an option, but I'm not sure of the best way to do it. Both databases have the same table structure, and since the oracle server is the 'source' of the data, there's no problem with having the data completely overwrite what's in SQL server every night.

So far it looks like having the oracle database dump the data to a set of text files, and then having the box with SQL server grab those files via ftp, and load it into SQL Server with bcp is the easiest option (without buying some expensive data-management tools, anyway).

An ODBC connection can be established between the two, so I was wondering if there's some other, more direct, solution...?

thanks
-Tom Stamm Received on Mon Dec 08 1997 - 00:00:00 CST