This is a migrated thread and some comments may be shown as answers.

Delete a project

10 Answers 166 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

10 Answers, 1 is accepted

answered on 29 Jul 2010, 04:42 PM

Hi Aaron,

Thanks for the feedback. Based on what we have seen so far, this is a feature we are going to look at adding to a future version of TeamPulse.

For right now, if you have not entered any data into the projects and have nothing to lose from deleting them, you could uninstall and reinstall TeamPulse, this will drop the current database and create a fresh one. Hopefully this helps you out.

Also, to play it safe, make sure to deactivate your install of TeamPulse before uninstalling.

Kind regards,
Jesse Dyck
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 03 Aug 2010, 08:15 PM

Hello Siingh,

Deleting a project through SQL is definitely doable, but there is some work involved due to triggers and constraints. In an effort to help the community between now and when we get a release out which includes the functionality via the UI, we have created a script to allow you to manually perform this action.

To use the script, you will need to know the Project ID of the project you wish to delete. This can be retrieved via the URL in your browser when the project is open. For example, when open to the Dashboard I get a URL like this:

http://localhost:9898/#/Project/3/Dashboard

In this case, the Project ID is 3.

To run the script, open SQL Server Management Studio and create a new query. Paste the contents of the script from below, then take the Project ID value and replace the placeholder text PASTE_PROJECT_ID_HERE with that integer value.

WARNING: *** This script is run at your own risk! Telerik is not responsible for any loss of data that may occur! ***

You are encouraged to perform a full database backup prior to running the script, as modifications cannot be undone!

USE TeamPulse

BEGIN TRAN DeleteProject

DECLARE @ProjectIDToDelete INT

SET @ProjectIDToDelete = PASTE_PROJECT_ID_HERE

Print 'Disabling all triggers...'

SET NOCOUNT ON

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#AllTriggers') AND type in (N'U'))

DROP TABLE #AllTriggers

SELECT T.Name as TrigName, o.Name as TabName, s.Name as SchemaName

INTO #AllTriggers

FROM sys.triggers T join sys.objects o

ON T.parent_Id = o.object_ID

JOIN sys.schemas s

ON o.schema_Id = s.Schema_ID

DECLARE TrigCurs Cursor

FOR SELECT TrigName, TabName, SchemaName FROM #AllTriggers

OPEN TrigCurs

DECLARE @TrigName varchar(250), @TabName varchar(250), @SchameName VarChar(250), @cmd varchar(1000)

FETCH Next FROM TrigCurs INTO @TrigName , @TabName , @SchameName

WHILE @@Fetch_Status = 0

BEGIN

SET @cmd = 'disable trigger all on ['+ @SchameName+'].['+@TabName+'];'

EXEC (@cmd)

FETCH Next FROM TrigCurs INTO @TrigName , @TabName , @SchameName

END

Print 'Deleting Project data...'

delete from AttachmentFile where ProjectID = @ProjectIDToDelete

delete from Attachment where ProjectID = @ProjectIDToDelete

delete from TestCase where ProjectID = @ProjectIDToDelete

delete from Task where ProjectID = @ProjectIDToDelete

delete from Hyperlink where ProjectID = @ProjectIDToDelete

delete from StoryPersona where ProjectID = @ProjectIDToDelete

delete from StoryRelationship where ProjectID = @ProjectIDToDelete

delete from StoryRichDescription where ProjectID = @ProjectIDToDelete

delete from Story where ProjectID = @ProjectIDToDelete

delete from SynchronizationError where ProjectID = @ProjectIDToDelete

delete from Area where ProjectID = @ProjectIDToDelete

delete from Iteration where ProjectID = @ProjectIDToDelete

delete from Timeline where ProjectID = @ProjectIDToDelete

delete from Persona where ProjectID = @ProjectIDToDelete

delete from ProjectUser where ProjectID = @ProjectIDToDelete

delete from ProjectSync where ProjectID = @ProjectIDToDelete

delete from ProjectTag where ProjectID = @ProjectIDToDelete

delete from project where projectid = @ProjectIDToDelete

Print 'Enabling all triggers...'

DECLARE TrigCurs2 Cursor

FOR SELECT TrigName, TabName, SchemaName from #AllTriggers

OPEN TrigCurs2

DECLARE @TrigName2 varchar(250), @TabName2 varchar(250), @SchameName2 VarChar(250), @cmd2 varchar(1000)

FETCH Next from TrigCurs2 into @TrigName2 , @TabName2 , @SchameName2

WHILE @@Fetch_Status = 0

BEGIN

SET @cmd2 = 'enable trigger all on ['+ @SchameName2+'].['+@TabName2+'];'

EXEC (@cmd2)

FETCH Next FROM TrigCurs2 INTO @TrigName2 , @TabName2 , @SchameName2

END

DROP TABLE #AllTriggers

COMMIT TRAN DeleteProject

Print 'Script Complete.'

Regards,
David Harris
the Telerik team