We are currently trying to update to the newest version of Promis-e and also move the SQL Database from one company server to another. I want to make sure I get all of my projects backed up before we make this transition. I thought there was a way to list all of the projects with Management Studio, but I am having difficulty in figuring out how to do that. Can you please help. We are currently on Select Series 1 (just a little behind) so the plug in utility to back up all projects does not work.
Thanks.
The list of projects is in the Project table of the database. So with SQL Server Management Studio, you can drill down in the Object Explorer tree into Databases > promise > Tables, right click the dbo.Project table, and select Open Table or Select Top 1000 Rows as the case may be. If using Open Table, take care not to make any changes to the data.
Alternatively:
Open Report Template Designer.
Select File > New.
Choose the "Customized by SQL Statement" option.
Paste the following into the box under "Customized by SQL Statement". SELECT name, prjpathFROM dbo.Project
Click OK.
Resize the columns as desired and Preview the report.
Save the report template and use Run Reports to view it again later.
Answer Verified By: RobG
Thanks,
That worked great.