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

In article <8qfmlq$inb$1_at_news7.svr.pol.co.uk>,   "Dave Leather" <david.leather_at_energis-squared.com> wrote:
> 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
Thanks ~~
But it still have problem in transfering "CLOB" and "text". Does ODBC support LOB ??
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 24 2000 - 21:06:30 CDT