• Thanks for your suggestion, I never worked on replication which do NOT apply deletions to subscribers and Need to test this as a solution- if it works and has not drawback or any issue. If it works it will really save alot of headache when moving data etc.

    I would also like to put some light on my other question to which I asked earlier.

    Shamshad Ali.