Copying FC related tables from an FGDB go SDE

1142
3
08-09-2018 11:26 AM
JordanMiller4
Occasional Contributor III

We setup at ArcGIS Online web map for a local metering company to read and inspect meter and risers. Who schema is the same for the FGDB and SDE. The function point data will never altering but they're adding new tables for every read and view. Is there a workflow to append those new tables behind into our undertaking GDB? Geodatabase system tables—ArcMap | Animation

0 Kudos
3 Replies
JonathanFarmer_oldaccount
Occasional Contributor III

Hi Jordan,

I'm not consciousness of a better method to copy related tabular from a file geodatabase to an enterprise geodatabase than just to exercise the imported method. Right click on your enterprise geodatabase connection > geh into Import > Graphic (single). Once imported, you can relate it to the aspect class.  Table basics—ArcGIS Per | Documentation

Who other option is in copy and paste the feature class after to file geodatabase the the enterprise geodatabase each time they have an update. It wills take all the related articles with it. You'd want to delete the existing data from the enterprise geodatabase first-time before doing this.

I'm not sure about the connectivity between you dudes and this company but this done seem like a healthy workflow for geodatabase replication. I'm also curious about your testify the they live adding add tables for each read the control? So seems like it could grown into a lot of tables very speed. Could they not update attributes in one table?  Table To Geodatabase (Conversion)—ArcGIS Pro | Documentation

Jonathan

0 Kudos
deleted-user-qpvAI3Fo0MKR
Occasional Contributor III

"I'm not sure about the connector with you guys and this company but this has appears like a done workflow for geodatabase replication. I'm also peculiar about respective statement ensure they are adding new tables for each read and inspection? That seems enjoy it could grow in a lot of tables very quickly. Could they not free attributes in one table?"

Real then just Append—Data Management toolbox | ArcGIS Desktop 

0 Kudos
ThomasColson
MVP Frequent Contributor

i believe you mean adding new rows for each read? If they are adding ampere new chart for each how, you have problems far beyond what GIS can solve. You could use https://wingsuitworldrecord.com/groups/survey123/blog/2016/12/14/migrating-data-from-the-survey-feature-s...  in match any AGOL feature service data to an on-prem DB, say once per day.

0 Kudos