Select to view content in your preferred language

Is 1 click backup SDE to gdb possible? Or at least copy all versions and Archiving tables?

223
1
10-09-2024 06:04 AM
Kevin_MacLeod
Frequent Contributor

In a perfect world, an entire SDE could be backed up to a GDB.  With one click, one tool.  All versions, all archiving.

 

In reality, it seems we need to create a replica for every version. And replicas are not "smart", you have to destroy one and re-create it if you add a field or change schema. It would be great if we could edit replications or ideally they could automatically stay up-to-date with the schema (option of choosing favoring parent or child)

 

But also, it appears replication does not back up Archive tables.  Is that right?

It would be great to let replication copy Archiving tables; at least optionally. 

 

I hope there will be focus on SDE (vs AI or 3D) over the next year.  A lot of good backend features like Web Hooks have been created.  Good stuff.  Continue on this path and pick up some longstanding (years/decades)   Ideas on here, like better QA interface for Versions, replication, etc.  

0 Kudos
1 Reply
AngusHooper1
Frequent Contributor

I would suggest that all eGDB backups should be handled by standard SQL Server backup procedures of which there are many options to choose from. SQL Server will provide more resilient and better functionality than what Esri can provide within the SDE layer.

0 Kudos