Delete enterprise geodatabase (SQL Server)

5706
7
02-12-2015 08:33 AM
DustinEdgeman1
New Contributor II

I have searched high and low and for some reason this functionality does not seem to exist? I have a SQL Server database with many tables I have created myself (in SQL) and made the mistake of enabling a geodatabase on that database. Now I have all these extra tables and stored procedures on a database I don't want. Restoring from a backup, rolling back, etc, are not options. I need something that will delete all tables, views, stored procedures, everything, that is created when a geodatabase is installed on a SQL database. Is this possible?

7 Replies
JoeBorgione
MVP Esteemed Contributor

Why not just do it through sql server manager?

That should just about do it....
0 Kudos
DustinEdgeman1
New Contributor II

Is there a list of everything created? Otherwise I'm going through all tables, views, programmability, checking everything one at a time to see if it's part of the geodatabase or not. This was added to a database with a lot of tables and views already.

0 Kudos
JoeBorgione
MVP Esteemed Contributor

Probably in TransAct SQL.  I don't know off hand.

That should just about do it....
0 Kudos
AlexPerez
New Contributor III

Easiest way is through SQL Server Management console.  Right click on the database you want to delete, select DELETE.  Follow through the command prompts (Yes, I'm really really sure I want to delete the database.) and you are set.

DustinEdgeman1
New Contributor II

You're misunderstanding, the problem is I have a SQL database that is full of tables and views (user created) and then it was geodatabase enabled. So I have a lot of objects in my database that I need to keep and use and a bunch of stuff that was added from the geodatabase that needs to be deleted. I definitely do not want to delete the database.

0 Kudos
AlexPerez
New Contributor III

Ah - my bad.  You may still be better off porting the tables and views that you want to save to a new database.  My suggestion would be to use a data compare utility like RedGate's SQL Compare.  Compare your target database with an empty geodatabase and copy the tables that don't match (after you have removed the new sde tables you added) to your new database.  SQL Compare writes out a script that you could modify to point at your new database.  Hope that helps.

0 Kudos
George_Thompson
Esri Frequent Contributor

Hi Dustin,

There is no tool to do this, I would not recommend removing the geodatabase objects (repository tables, stored procedures, triggers, etc...) from the database, especially if SDE or another user in the geodatabase owns any objects. If this occurred it could corrupt the database as a whole.

I think the easiest and safest way it the process that Alex P. referenced:

"You may still be better off porting the tables and views that you want to save to a new database."

Hope this helps...

-George

--- George T.