Re: URGENT !! Please give me suggestions~~~~~`

From: Dave Leather <david.leather_at_energis-squared.com>
Date: Fri, 22 Sep 2000 14:21:37 +0100
Message-ID: <8qfmlq$inb$1@news7.svr.pol.co.uk>

If you dont want to buy a gateway from oracle, then you could create a link in your MSSQL db using odbc and setup a job on the MSSQL db to resync the data.

Dave
"Chun-Yen" <agi_at_haa.com.tw> wrote in message news:8qeonb$oel$1_at_nnrp1.deja.com...
> Hello,geeks,
> I have an Oracle8i(on Sun) and a SQL Servers.
> Both of them have the same schema.
> Oracle is our master datasource, whenever any data change I need
> to sync with SQL Server.
> What can I do to achieve my goal ??
> I need some suggestions to convince my manager of my solution.
> If I have no solution, he decides to use SQL Server.....:( hmm....
> Tolerable time of data non-consistency on both server is can be hour.
>
> DO appreciate for your help !!!!
> ps. my characher set is ZHT16BIG5 ( double byte )
>
> Agi Chen
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 22 2000 - 08:21:37 CDT