I am trying to configure a replication between SQL server 2000 and Oracle
server. I want to make SQL server as publisher and distributor and Oracle
server as subscriber. Replication wizard didn't allow me to set oracle as
subscriber.
Can anyone give me a suggestion or provide useful links?
Re: merge Replication with a Notebook not in domain ... not associated with a trusted SQL Server connection.... I have set up all SQL Server login in both publisher and subscriber.Also ... Looking for a SQL Server replication book?...subscriber... (microsoft.public.sqlserver.replication)
Re: Server to server Replication ... Replicated data is mostly read-only at the Subscriber.... You need updates to be propagated on a transaction basis,... Use snapshot replication or transactional replication with immediate ...Paul Ibison SQL Server MVP,... (microsoft.public.sqlserver.replication)
Re: IOT, memory and transaction time ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server... (comp.databases.oracle.misc)
Re: Problem with merge replication ...subscriber changes before the new snapshot comes down. ... Looking for a SQL Server replication book?... I use merge replication with windows CE clients and SQL Server 2005. ... If someone collects data in an existing table on the client (the ... (microsoft.public.sqlserver.replication)
Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec ..."Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server... admitted they can happen in Oracle, I guess Oracle should never been used ...isolation level but you will always disagree because you follow doctorine ... (comp.databases.oracle.server)
