Table replication question

[zgb]

Hi, I'm using MS SQL server 2005.

I have two identical databases - with one exception: they have different
names (etc database1 and databse2), but their structure is completely same.

Is it possible to replicate one table between those databases?

Regards

[Erland Sommarskog]

zgb (zg***@vip.hr) writes:

I will simplify configuration:
I have two pairs of master - backup servers, each pair is replicated in
both directions (merge replication). Let's call them master1, backup1
and master2, backup2.

Also I have two rooms, room1 (here are master1 and backup1) and room2
(here are master2 and backup2). Databases on all four servers have
completely same structure, but databases in room1 have name db1, in
room2 db2. Between two rooms there is no any replication, imagine two
systems that are working completely separated, each in his own room.

What I want to do is establish replication between two rooms but in way
to replicate only one table - I'll call it myTable. As databases are
identical I have myTable on all four servers. Problem are names of
databases (on room level). Also complete replication inside room1 and
inside room2 must remain. Unfortunately I can't rename databases.

So, result must be: both direction replicated databases on master1 and
backup1, both direction replicated databases on master2 and backup2,
myTable replicated on all four servers.

Thanks for the details! I am very glad that I did not offer any
suggestions to the first question, becase they would all be off.

I would suggest that you post your question to
microsoft.public.sqlserver.replication, where I believe some people
with very good experience of replication hangs out.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[zgb]

Erland Sommarskog wrote:

zgb (zg***@vip.hr) writes:

>I will simplify configuration:
I have two pairs of master - backup servers, each pair is replicated in
both directions (merge replication). Let's call them master1, backup1
and master2, backup2.

Also I have two rooms, room1 (here are master1 and backup1) and room2
(here are master2 and backup2). Databases on all four servers have
completely same structure, but databases in room1 have name db1, in
room2 db2. Between two rooms there is no any replication, imagine two
systems that are working completely separated, each in his own room.

What I want to do is establish replication between two rooms but in way
to replicate only one table - I'll call it myTable. As databases are
identical I have myTable on all four servers. Problem are names of
databases (on room level). Also complete replication inside room1 and
inside room2 must remain. Unfortunately I can't rename databases.

So, result must be: both direction replicated databases on master1 and
backup1, both direction replicated databases on master2 and backup2,
myTable replicated on all four servers.

Thanks for the details! I am very glad that I did not offer any
suggestions to the first question, becase they would all be off.

I would suggest that you post your question to
microsoft.public.sqlserver.replication, where I believe some people
with very good experience of replication hangs out.

I will try at suggested group, thank you for your effort, you are very kind.

Regards