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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:14:33
|
| Arfat writes "I want to setup merge replication,I get my database with data and all its objects on the machine which is goign to be Publisher and Distributor.I create the Database with Table with primary keys on Subsriber Machine.I have not yet created the Foreign key relationship on subsriber which normally i want to create after creating the subscriber for the publisher.So the need is to create a publication with Article filter using logical records which will publish only the data not the schema.I tried doing twice, once it failed as i tried to change the option false of articles not to copy objects like Primary keys, check constraint and not to keep the existing schema but it failed.Next I tried with not touching or manipulating the article properties, but it copied the schema and created the foreign keys on the subsriber.Can any one provide me with a solution to just publish the data not the schema.Thanks,Arfat Chougualy" |
|
|
|
|
|
Merge replication in SQL 2005 (Stoping Schema Change)