I’ve got two databases on the same server - located in “Live/” and a “Sandpit/”. The database is a bespoke content management tool. We’ve given a whole load of content editors access to the Sandpit version, and made the Live version read only. Within the common design there is 5 different forms, one of which we want to refresh from the Sandpit to Live every 24 hours, the other 4 will only be refreshed once every 3 months.
My main problem is getting the replication agent to update the one form type from Sandpit to Live, without the replication deleting the other 4 form types at each replication. In the current test setup, the replication is a ‘pull’ from Sandpit to Live.
I have tried the space saver and advanced options, built views to use in replication and alike, but still end up deleting the “other” documents from the application.
I’m also using an agent to trigger the replication as well, as I couldn’t seem to set up reliable replication intra-server.
I can ‘bounce’ the replication via a second server if this helps solve the problem.
Any help/pointers to getting this fixed, either of a positive or negative nature is appreciated.
Lawrence.