all groups > sql server replication > may 2006 >
You're in the

sql server replication

group:

heterogeneous replication


heterogeneous replication ochec
5/14/2006 6:13:02 PM
sql server replication:
Hi,

Just hoping to get any info on Replicating a progress DB to sql server 2005.
I connect to progress DB via linked server in sql through ODBC.

I there a doc out there that explains this?.
I found 'Programming Snapshot or Transactional Replication from
Heterogeneous Data Sources' but this applies to sql 2000 and the sample
replicates sql db to sql db and uses sql-dmo.

I understand there's RMO/SMO in sql k5 but haven't been able to get enough
info to be able to do what I need to do.

Thanks in advance.
Re: heterogeneous replication Jack
5/15/2006 12:00:00 AM

Forgot that sqlserver, use Oracle heterogenous services instead ;)

[quoted text, click to view]

Re: heterogeneous replication Hilary Cotter
5/15/2006 2:26:11 PM
Why should I plunk down $10k when you can build it for free? The SQL 2000
sampub code sample works with SQL 2005 as well.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Re: heterogeneous replication Jack
5/16/2006 12:00:00 AM
No need for spending ;)
Oracle XE comes with Generic connectivity (aka Hetereogenous Services)

[quoted text, click to view]

AddThis Social Bookmark Button