MysteryJimbo (8/15/2012)
Antony Symonds (8/15/2012)
Im planning on running the insert on the subscriber... it will then I assume try to send that insert to the publisher and find it there..Will this just cause a conflict that I can fix or will it mess with replication too much?
You dont mention what replication this is so I've made the assumption (possibly incorrect) that this is one way, transactional as this generally the most common. If it is then it is one way and no it wont.
If its merge you can insert on the subscriber and resolve the conflict in conflict manager.
Hi,
Sorry I must of missed saying it was a Merge Replication... do apologise. 🙂
So yes its a merge replication... and tablediff has generated the insert commands to re insert the data with identity insert ON so it would mirror precisely what it says in the table at the publisher...
The database is very big and I would not be able to re replicate it from scratch... that is my nightmare scenario.. long distance to the publisher server and we have poor speed lines due to being out in the middle of nowhere.
So you would say it should be ok and I jsut need to fix the conflicts?
Thanks
Antony