shrug-l: Arcgis10 SDE: Archiving

Griffin, Jason jgriffin at
Mon Sep 19 10:28:44 EDT 2011

Archiving in SDE, simply amazing!

Okay SDE administrators this is your time to shine.  Have you ever been asked to restore that polygon that Bob just deleted, a minute/hour/day/week (Why Bob, why???) after he saved/posted his changes, or have you ever had to create a "snapshot" of the database at a specified time period to maintain a history of changes?  There are many more scenarios that fit the need to start archiving your datasets but for brevity we will stick to those two cases...

Imagine being able to have a historical access to your data where you can specify the Month, Day, Hour, and even Second and then see the data at that point in the past.  Archiving allows that.  Imagine getting an inquiry from a stakeholder requesting an old project boundary that since has been updated.  We can get to that boundary now, and the original attributes as well.  Remember that boundary that got deleted and we had to find a shapefile exported a year ago and pray that it didn't have any other changes made to it before its accidental deletion?  Connect to the database just before it was deleted start an edit session on default, and then copy the missing feature from the historical connection and then paste it back into your database.

To get Archiving working for you, upgrade to ArcSDE v10.  If this is not possible start making a case for the upgrade...

Connect to SDE w/ administrative rights, right-click on the Feature Dataset, Feature Class, or stand alone Table you wish to start Archiving, and then:

Right-click on your data, then go to "Archiving,"  and choose "Enable Archiving."

[cid:image003.jpg at 01CC76B6.E87DDD70]

Depending on the size of the dataset you may have to wait a while for it to finish.  There will be no dialog box or pop-up to tell you it is completed (You will only get the hourglass so please be patient).

Great, my data is setup for Archiving, how do I start using this amazing feature...

Browse to/expand your database connections folder in catalog, then:  Right-click on your database connection, and then choose "Database Connection Properties"

[cid:image006.jpg at 01CC76B6.E87DDD70]

Next, click "Change" to choose your version, and then choose the option for "This Connection Refers to a Historical Version," and then set the point in time you want to visit.

After you change your connections version to the time of your choice you now have to add your dataset to the map from the updated connection to see the historical dataset.  For good measure, and if you had the connection open while you were changing the connection settings you should right-click on your connection and choose disconnect, wait for the red X to appear, and then add the historical data to the map.

After you are done messing w/ the past just remember to change the connection back to default or the version that you need to be connected to, and Done!

That's the primer on Archiving.  I hope it helps!!!  It's really cool.  For more information on Archiving open up ArcMap and search Archiving in the help.

...Apologies to any Bobs out there I needed to name my fictional user :)

Jason A. Griffin, Ext. 33613 | BTS Senior Technology Specialist, GIS Dev. | Pinellas County Government, Business Technology Services [BTS] | 400 S Ft. Harrison Ave | Clearwater, FL  33756 | Tel: 727-453-3613 | Cell: 850-408-6743 | JGriffin at<mailto:JGriffin at>|

-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 17908 bytes
Desc: image003.jpg
Url :
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 44500 bytes
Desc: image006.jpg
Url :

More information about the SHRUG-L mailing list