Hi
I tried posting this query in microsoft.publi c.sqlserver.pro gramming but got
no response.
I am new to replication but I am trying to setup up a transactional
replication of tables from one database to another in MSSQL 2000 (SP2).
My target tables have primary keys defined. Under publication properties I
go to the snapshot tab and for each table I clear the check box that says
"Drop the existing table and re-create-it" and "clustered Indexes." On this
page the nothing is checked. for each table.
Whenever the subscription is reinitialized it drops the primary keys on my
target tables
and replaces them with a unique clustered index on the column that used to
be
the Primary key.
Is this normal? Is there anyway to stop it from doing this?
I don't plan to send the snapshot more than once and let transactional
replication take over for keeping my source and target in sync, but if I
ever have to reinitialize the subscription, it would seem that I (or
someone) will
have to take the a second step of manually dropping these clustered indexes
and recreating the primary keys on the target table.
Thanks in advance.
--
-Dick Christoph
--
-Dick Christoph
dchristo@mn.rr. com
612-724-9282
I tried posting this query in microsoft.publi c.sqlserver.pro gramming but got
no response.
I am new to replication but I am trying to setup up a transactional
replication of tables from one database to another in MSSQL 2000 (SP2).
My target tables have primary keys defined. Under publication properties I
go to the snapshot tab and for each table I clear the check box that says
"Drop the existing table and re-create-it" and "clustered Indexes." On this
page the nothing is checked. for each table.
Whenever the subscription is reinitialized it drops the primary keys on my
target tables
and replaces them with a unique clustered index on the column that used to
be
the Primary key.
Is this normal? Is there anyway to stop it from doing this?
I don't plan to send the snapshot more than once and let transactional
replication take over for keeping my source and target in sync, but if I
ever have to reinitialize the subscription, it would seem that I (or
someone) will
have to take the a second step of manually dropping these clustered indexes
and recreating the primary keys on the target table.
Thanks in advance.
--
-Dick Christoph
--
-Dick Christoph
dchristo@mn.rr. com
612-724-9282
Comment