Community
Select to view content in your preferred language

Update Replica Schema

611
2
08-22-2011 02:08 PM
BenYoungs
by
Deactivated User
‎08-22-2011 02:08 PM
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!
0 Kudos
2 Replies
CherylCleghorn
by Esri Contributor
Esri Contributor
‎08-23-2011 08:53 AM
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
0 Kudos
BenYoungs
by
Deactivated User
‎08-31-2011 07:29 AM
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,
0 Kudos