Get .SDE Schema with Utility Network to File Geodatabase

Question

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.

Has anyone else experienced this?  Is there a workaround?

RPGIS · Answer

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.

MitchHolley1 · Answer

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.

RPGIS · Answer

Hi @MitchHolley1,

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