topic Re: Update a version of a feature class from an enterprise database in ArcGIS Pro Questions

Update a version of a feature class from an enterprise database

lmatteo — Wed, 18 Oct 2023 13:40:39 GMT

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.

Re: Update a version of a feature class from an enterprise database

JakeSkinner — Wed, 18 Oct 2023 14:01:12 GMT

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.

Re: Update a version of a feature class from an enterprise database

lmatteo — Thu, 19 Oct 2023 07:49:46 GMT

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