I need a tool or a process that does the reverse of the 'Enable Enterprise Geodatabase' tool.

Question

I have run the 'Enable Enterprise Geodatabase' tool from ArcGISPro 3.5.1 against a SQLServer database. This has created a number of SDE objects in the dbo schema.

How do I cleanly remove these SDE tables, views, stored procedures etc and in doing so effectively remove the SDE geodatabase without deleting the whole database?

VinceAngelo · Answer

Well, if you had used the sde schema, not sdo, and didn't register any user tables, then dropping the sde schema (including contents) could have been enough.  And if you can identify all the dbo tables that were added (most have 'sde_' or 'gdb_' prefixes), you might be able to pull this off (again, provided you didn't register any tables).

Once you've registered a table with the geodatabase (with either sde or sdo model), the cleanup becomes significantly more complicated, and falling back to the last backup (Ryan's suggestion) makes good sense.

- V

George_Thompson · Answer

I agree with @RyanUthoff on this.

If you do not have a backup, create a new SQL Server database and copy the data over.

ryanuthoff · Answer

There is no going back once you run the Enable Enterprise Geodatabase tool on a DB. Your best bet is to restore your DB from a backup from before you ran the tool. You can try deleting all the Esri system tables, stored procedures, etc. in SSMS, but the only for-sure way that you'll be able to eliminate anything Esri related in the DB is to restore from a backup since before you ran the tool.