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.
| Author |
Topic |
|
jonathan_henry
Starting Member
1 Post |
 Posted - 2010-02-25 : 13:23:30
|
| Hello,While the publisher was creating the publication the following appeared in the log:the foreign key 'xyz' will not be scripted forarticle 'abc' because it references the key contraint'123' that is replicated only as an indexI cannot find any reference to this message anywhere.Table abc has a foreign key that is an index in another table, but not a key. Why can't this replicate?Thank you for your attention. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 14:29:12
|
| it just means that the foreign key won't be scripted when the snapshot is generated.why are you publishing keys?i typically set up a new subscriber with a backup of the publisher. or if i don't want the entire database, i'll script out the tables that i'm going to replicate and create them at the subscriber (with any constraints i want).then i only replicate tables |
 |
|
|
|
|
|
Foreign Key that is Non Key Index Error