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 - 2002-09-27 : 08:30:59
|
| CLEBER writes "Hello,I'd like you suggestion to find the best solution in the following case: - I have 5 SQL Servers 2000 - Personal and I need to replicate the data from each one in a unique server that is runnig a SQL Server 2000 - Standard, and we can't have a gap over 5 minutes betwen each replication. What is the best solution for this case? Just for information the 5 computers are running the W2K Professional and the other one is running the W2K ServeR.Best Regards & Thanks in advance for the attention.Cleber PolliAlstom TransportIconis Team55-11-38556207" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-08 : 13:04:18
|
| This is probably going to be heavy on the server. The best option I can see is merge replication to initially set it up and then transactional replication with immidiate updating subscribers. That is really kinda ugly there. Couple restrictions to this although, every table will need a integer identity coloumn (sql can/will add this itself if need be... watch out for implecations with your insert statements on that). This will also be pretty heavy on resources, especially across the network. I've set up something simular before though, it will work. Email me if you need further help. Or just post on here.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
SQL SERVER 2000 - Replication