Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Deletion of all projects except one

web-app

I have taken backup of the production Gemini database (2.0.2) and restored it on test machine. I need to delete the details of all the projects except for one project. How do I do this from the SQL scripts?
Enn
· 1 		Enn
Tuesday, June 8, 2010, 8:16:01 AM
Replies (6)
helpful
0
not helpful

Run the geminideleteproject stored procedure passing in the project id.
eg. exec geminideleteproject 2
Mark Wing
· 9108 		Mark Wing
Tuesday, June 8, 2010, 10:10:55 AM
helpful
0
not helpful

Will the same SP work for the ver 2.0.2 database as well?
Enn
· 1 		Enn
Tuesday, June 8, 2010, 10:44:15 AM
helpful
0
not helpful

Yes, it should do as it is part of 2.0.2
Mark Wing
· 9108 		Mark Wing
Tuesday, June 8, 2010, 11:49:08 AM
helpful
0
not helpful

The SP geminideleteproject has lots of Delete statements which act on tables with names beginning with gemini whereas 2.0.2 version does not have table names starting with gemini_. How will the SP work on these tables?
Enn
· 1 		Enn
Tuesday, June 8, 2010, 12:51:17 PM
helpful
0
not helpful

The SP is already in 2.0.2 and is used by the web app to delete projects. I think you are looking at a newer version of the SP (3.x).
Mark Wing
· 9108 		Mark Wing
Tuesday, June 8, 2010, 1:15:13 PM
helpful
0
not helpful

Sorry [:$]. I was looking at 3.5 installation DB which is installed next to 2.0.2 version DB.

 
Enn
· 1 		Enn
Tuesday, June 8, 2010, 1:38:22 PM