Select to view content in your preferred language

Get .SDE Schema with Utility Network to File Geodatabase

117
3
a week ago
MitchHolley1
MVP Alum

I am using ArcGIS Pro v3.3.6 and I'm trying to get the schema of an .SDE geodatabase (SQL Server) containing a Utility Network (and other feature classes/tables) to a File Geodatabase.  I've tried running the 'Export to XML Workspace' and the export works fine, but every time I try to import it throws an error. 

 

I've even tried 'Generate Schema Report' as a JSON, then converting to an XML for import, but that also fails.

MitchHolley1_0-1763477802163.png

 

Has anyone else experienced this?  Is there a workaround? 

0 Kudos
3 Replies
RPGIS
by MVP Regular Contributor
MVP Regular Contributor

Hi @MitchHolley1,

Have you tried running the generate schema report in pro. I typically use that when identifying changes between test and production databases.

 

0 Kudos
MitchHolley1
MVP Alum

Thanks for the reply.  Yes, I have.  The screenshot in the post is the error thrown by the 'Convert Schema Report' tool.  Generate Schema Report only gives me a flat file, I need a file geodatabase.

 

0 Kudos
RPGIS
by MVP Regular Contributor
MVP Regular Contributor

Have you tried creating a replica schema to see if that will work? I have not used those myself but based on what I have read it will create a local copy of the exact features you need. Whether or not that will work for you is unknown but you could give that a try.

0 Kudos