"DB2" <db2team@hotmail.com> wrote in message
news:a78ec628.0403312238.178c332c@posting.google.com...
> StarQuest Data Replicator is a very fast solution to replicate large
> tables, quite easy to setup as well. It was originally developped with
> Microsoft, so the SQL Server integration is quite good.
>
> Bob
>
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:<O7THNgsFEHA.3132@TK2MSFTNGP12.phx.gbl>...
> > Thanks for the feedback Hilary.
> >
> > I've also had a look into the replication API but that's probably too
much
> > of a programmatic solution for this client.. They're currently keen on a
HiT
> > product called DBMoto which is here:
> >
> > http://www.hitsw.com/products_services/dbmoto/dbmoto.html
> >
> > Looks like a fairly new product to me, but might be a lot easier than
coding
> > SQL replication APIs..
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "Hilary Cotter" <hilaryk@att.net> wrote in message
> > news:%23OyAPXlFEHA.3568@tk2msftngp13.phx.gbl...
> > > I've used DataMirror. It does work replicating from hetergeneous data
> > > sources to SQL Server. I have never used it to replicate from Oracle
to
> > SQL
> > > Server.
> > >
> > > There are some bugs with it. For instance if you have a view and a
table
> > > with the same name, but different owners; it can't distinguish between
> > them.
> > > Another problem is that it doesn't clean up the msrepl_commands and
> > > msrepl_transactions table effeciently.
> > >
> > > On the plus side is seems very reliable once configured.
> > >
> > > To replicate from Oracle to SQL Server you can use the distribution
> > control,
> > > or I believe you can replicate from Oracle 9 to SQL Server, I was
hoping
> > to
> > > try to repro this, but haven't been able to yet, so I can't give you a
> > > definitive answer.
> > >
> > > I can't comment on any of your other questions.
> > >
> > >
> > > "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> > > news:u9OHV0kFEHA.2052@TK2MSFTNGP11.phx.gbl...
> > > > **
> > > > This is re-posted from the private MVP newsgroup following no
response.
> > > > Hopefully someone's got some experiences with Oracle -> SQL Server
> > > > replication and can help me out here (:
> > > > **
> > > >
> > > > I've been asked for an opinion on how to best perform Oracle -> SQL
> > Server
> > > > 2K replication but have to admit that although I know a few tools
that
> > > > perform Oracle -> SQL replication, I don't know what the
differentiating
> > > > factors are between those tools.
> > > >
> > > > The basic requirements are to push Oracle customer data to a SQL
Server
> > 2K
> > > > staging database which is in turn polled by various other local SQL
> > > > databases. The process should be close to real time and provide
> > incremental
> > > > changes due to large size of data to be replicated. Transformation
is
> > not
> > > > highly sought after for initial implementation but of course, this
could
> > > > become a future requirement.
> > > >
> > > > I'm aware of:
> > > > (a) DataMirror
> > > > (b) DBMoto
> > > > (c) StarQuest
> > > >
> > > > Can anyone provide either:
> > > > (a) Personal experiences (positive or negative) on the use of above
> > tools.
> > > > (b) Location of whitepapers / resources on achieving Oracle -> SQL
> > > > replication.
> > > > (c) Alternative tools.
> > > > (d) Any "big picture" issues.
> > > >
> > > > Regards,
> > > > Greg Linwood
> > > > SQL Server MVP
> > > >
> > > >
> > >
> > >