The Esri Community
Services & Programs
GeoNet Resource Hub
to create and rate content, and to follow, bookmark, and share content with other members.
SDE Layers Tool
Idea created by
on May 2, 2013
1 vote up
3 votes down
It would be nice to have a tool that creates a text file listing all of the layers in SDE. I have a script that exports layers into a file geodatabase for archiving purposes.
This content has been marked as final.
Show 1 comment
(Required, will not be published)
May 3, 2013 10:52 AM
You might want to expand a little on your requirements or exact needs with the text file. For what purpose would the text file be used for? There is already arcpy.ListFeatureClasses and this could be exported to a text file quite easily in python or use CopyFeatures to the archive geodatabase.
Additionally you could run traditional queries against sde.sde_layers table using Access, Excel or SSIS.
Another tool that might be useful would be the Geodatabase X-Ray tool. It can create XML or an HTML Data Dictionary of all items within an ArcSDE, File or Personal Geodatabase.
Show 0 Likes
Retrieving data ...
Collector will not load maps on Android 7.0
Tips and Tricks for Working with 3D Data on the ArcGIS Platform
What's Coming: Introducing User Types
Feature service not executing DB triggers
ArcGIS Server Pricing