Update a version of a feature class from an enterprise database

[lmatteo]

I'm using an enterprise database with two versions : MAJ and LTD.
In the MAJ version, I'm updating the data, mainly adding new data and modifying attributs.
The LTD version is used to create maps for the portal and only see the data from the last big update.

As an example, let's take a feature class FCa with its two versions : FCa.MAJ and FCa.LTD. During 1/2 months, I'm updating FCa.MAJ and then, I want to update FCa.LTD from FCa.MAJ, thus, both are the same and LTD version is up to date.

I used the Add Append function from ArcGIS Pro with FCa. MAJ as input dataset and FCa.LTD as target dataset. To select the two FC, I have two sde connection files corresponding to each versions.
To update only the data and not adding all the data (I don't want to dupplicate the data), I thus selected a target field which is globalid (a same entity in both FCa version have the same globalid).

Doing this for an autonomous table worked like a charm, but for a FC, the Add function is noted as "succeed" but nothing changed in the LTD version of the FC. Edit : I try to do it again, and it didn't update any data.

Thank's for your help,
I'm open to suggestion if using versions is not the best practice to do what I want.

[JakeSkinner · Accepted solution]

Hi @lmatteo,

I would recommend making version MAJ a child version of LTD.  When publishing your service, make sure you are connected to the LTD version.  When you are ready to update the LTD version, you can perform a reconcile/post from MAJ to LTD and the service will be updated as well.

[lmatteo]

Hi @JakeSkinner, it works like a charm 🙂 thank's !
I have both versions a childs of DEFAULT version. I put MAJ a child to LTD and then I perform the update with reconcile/post as you suggested.

Thank's again for your help