Replication: Applying initial snapshot is dropping existing tables in the database.
-
Hello All, I am implementing merge replication over internet, having following scenario . Publisher has some 14 tables in the database out of which only 7 are to be p ublished, because only 7 tables are having information which will be changed hence no need to publish. At the subscriber side also there will be 14tables and out which 7(published by publisher) will be receive updates from the publisher vis synchronizatio n. Now come to the problem:- When I am trying to apply initial snapshot its it trying to drop existing ta bles (which I don't want), since table contain froeign key constraint(I came to know this by seeing output file of merge agent) and because of master-de tail relation it is not able to drop it and giving error. I don't want dropping and recreation of the tables in the databse as I am ha ving correct schema at the subscriber side can anyone help me??? RuchirDhar Dwivedi Software Engineer Windowmaker Software Pvt.Ltd. Baroda, India.