topic Update Replica Schema in Data Management Questions

Update Replica Schema

BenYoungs — Mon, 22 Aug 2011 21:08:20 GMT

All,

I have set up two-way replication between two SDE instances, which works well. I know that it is best practice to have a well established, static schema to base your replication on, but my data is very dynamic and I would like to have the ability to add feature classes to the replica schema from time to time. As far as I know this isn't supported in core functionality without un-registering the replica, making the schema changes, and then re-registering the replica.

I saw some code on the archived forums in VBA/VB.Net that looked like a possibility, but I wanted to hear if anyone else has successfully done this recently.

I am at 9.3.1 in this instance but I also have other instances in 10 that would require this same functionality.

Thanks in advance!

Re: Update Replica Schema

CherylCleghorn — Tue, 23 Aug 2011 15:53:02 GMT

Hi Ben

The following link has instructions on how to achieve this:

How to add a feature class or table to an existing replica

Regards
Cheryl

Re: Update Replica Schema

BenYoungs — Wed, 31 Aug 2011 14:29:50 GMT

Cheryl,

I've seen that link before, and it seems like that would be the perfect solution. However, In the environment that I work in I am unable to access an IDE to implement C# or VB.NET code. Is it possible to migrate the VB.NET code to VBA and run through the VB Editor in ArcGIS? Or is there another possible method to enact this without an IDE?

Thanks,