Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-06 : 09:33:55
|
John writes "We currently have two SQL Server databases. PUB1 database (SQL Server 2000) and SUB1 database (SQL SERVER 7.0). In order to keep the two databases in sync with "real-time" and "ordered messages", we are using MSMQ 2.0 queues to publish and retrieve messages. Since there are no data transformations, we would like to do this thru publish and subscripe type of replication between the two databases? Can replication from one temporary table be used to transfer data to another database staging table for replication purposes? We need guaranteed delivery of messages (which MSMQ 2.0 persistent messages offers). Can SQL Server replication provide us with that? If "YES", what is the best type of replication for this problem? Please advise?
Hope to hear from you soon.
Thanks,
John Portnov" |
|
|
|
|
|
SQL Server 2000 replication with SQL Server 7.0