PS2007 - Create Empty databases

T

TroyS

I have an existing project server 2007 environment. I would like to create a
'test' PWA and start off using blank databases rather than the ones that i
have which has data.

In PS2003 use to be able to manually create a blank project server database;
There was only 1 db at that time.

Is there a similar method for installing blank Project Server databases (all
4 of them) and then provision the the PWA site in Sharepoint Central
Admin...?

Is it a matter of just creating 4 databases in SQL Server and does the PWA
Site Provisioning step in Sharepoint Central Admin create the schema to those
4 databases?

Thx for the help
 
G

Gordon

Hi Troy,

You can provision another PWA instance under a seperate Web Application
during which process you can specify another set of databses. This new
instance (Test) will have a seperate url and point to this new set of
databases that you can use as a test environment.

Hope this helps.
 
T

TroyS

Gordon,
does the PWA Provisioning create all of the schema (tables, stored procs,
views, etc) that are part of the Project Server 4 database structure?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Provisioning failed because the databases specified did not match 0
Migration of Project Server From One Envirnoment to another 3
Database recovery of SSP does not "remember" PWA site 2
Provisioning PWA Site Failed 1
Restoring Project databases and sites 3
Database restore of SSP does not "remember" PWA site 3
Delete a PWA Instance [MOPS2007] 1
Attempting to re-create PWA site gives error "....name already exi 1

Top