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

How many records are you talking about?

Brad

Tom Stamm <stammt_at_bah.com> wrote in article <348C1528.93ADECEB_at_bah.com>...
> 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 Tue Dec 09 1997 - 00:00:00 CST