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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-07-12 : 06:21:06
|
| We run a small business with a LAN of 2 pcs, a laptop pc, and a web server that runs Win2k Server with Exchange on it. My pc is used for most of the development and it also houses SQL Server (Developer) 2k. We have SQL Server (Developer) installed on the other network pc as well. Here's the problem: We sometimes have to take my pc with us to use at different sites (with no internet connectivity at the time). When this happens, any data access on our web site is 'down' because our web data is in the sql server db on my machine. I want to replicate the db on the other pc so that we can take that machine to the different sites. I am having trouble getting this done.Can someone give me some direction? Is there a good tutorial or a book or whatever somewhere? I am really in need of some sql server admin knowledgebase.Thanks!! |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2003-07-20 : 22:16:17
|
| Hi Bobba,Portable PC and Office PCYou could setup either snapshot replication on Office PC or merge replication on Office PC... to keep data "current" on the Portable PC (so I suppose the Office PC will be the db the web server uses)I think the merge type of replication might suit your needs. It is continuos - every row added or changed gets replicated over to the other database/pc immediately.Then before you take the portable pc out of the office, you would just stop the merge agent before disconnecting from the network.When you return to office, start merge agent and it will 'catch up' on all the changes that have been made while you were out.This scenario assumes that the pc remaining in the office would be the 'Publisher' and the pc you take out is the 'Subscriber'Question: If you will make data changes on the portable pc you take out of office the office... that must be replicated onto the office pcthen you may need bi-directional merge repl which is more complex to configure, but still possible to do.The replication subject matter in SQL Server Books On Line (BOL) is weak in my opinion. Does this help? John |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2003-07-20 : 22:20:45
|
| ... well I see from your Initial Snapshot post that you have already setup merge repl. John |
|
|
|
|
|
|
Replication/Admin Help