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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication between two database's?

Author  Topic 

hesta96
Starting Member

9 Posts

Posted - 2002-11-19 : 09:24:47
I have a question, that maby is easy, but I ask it anyway.
On our "real" data-system, we have a internal DB-server and one external. We have a replication between them that is working. But on our developer-system we only have one computer but I would like to have two database's on that computer with a replication between them. So my question is:

Can on DB-server be both publisher and subscriber?
We have MS SQL SERVER 2000

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-11-19 : 11:58:44
I've never tried to configure it that way, but I don't see why not. Since you have SQL 2000, why not install a named instance on your dev server. Then your replication model in dev would more closely represent your production environment.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -