|
Home > Archive > MS SQL Server > August 2005 > txn replication question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
txn replication question
|
|
| maxzsim 2005-08-30, 7:23 am |
| Hi,
I would like to check on txn replication
if server 1 is to be a publisher and server 2 is to be a subscriber
if db1 of server 1 is to be replicated over to db2 of server 2
but in db2 , there is no tblA , can replication still occur ?
if tblA of db1 has a P.K , will it be replicated over as well ?
tks & rdgs
| |
| swapna 2005-08-30, 7:23 am |
| Hello ,
this is possible we have to say uncheck the box for 'enforce replication'
,so this can be done .no need for the primarytable.
"maxzsim" wrote:
> Hi,
>
> I would like to check on txn replication
>
> if server 1 is to be a publisher and server 2 is to be a subscriber
> if db1 of server 1 is to be replicated over to db2 of server 2
> but in db2 , there is no tblA , can replication still occur ?
>
> if tblA of db1 has a P.K , will it be replicated over as well ?
>
> tks & rdgs
| |
| maxzsim 2005-08-30, 9:23 am |
| hi ,
if i need the PK to be replicated over so i'll tick "enforce replication" ?
rdgs
"swapna" wrote:
[color=darkred]
> Hello ,
>
> this is possible we have to say uncheck the box for 'enforce replication'
> ,so this can be done .no need for the primarytable.
>
> "maxzsim" wrote:
>
|
|
|
|
|