Hi,
I have a table without primarykey. Will i able to replicate this table. (I
will not able to create a primary key in this table)
If so, how will be the conflicts be identified ?
Please advise
Rgds,
Soura
Your two options are
1) creating a primary key (not an option)
2) creating a view and have the application talk to the view, then the view
will be of a table with a pk
3) snapshot replication - this will not work if the table is large and you
want near real time synchronicity
4) use a manual tracking method, i.e. with triggers which will keep a table
in sync which you will replicate.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:66714C33-10CC-4A6F-8A58-00431A808970@.microsoft.com...
> Hi,
> I have a table without primarykey. Will i able to replicate this table. (I
> will not able to create a primary key in this table)
> If so, how will be the conflicts be identified ?
> Please advise
> Rgds,
> Soura
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment