Setup of Dev Database

[Thad McLemore]

Our Project Server Admin setup a separate instance of Project Server for our
development environment. Of course the database on the backend doesn't have
any of our production data actually in it. Can our DBA just copy the
production database over to our dev environment so that we can more
accurately test? Is there a better way to do this? The security in the DEV
is obviously different than the Prod so I'm a little leary of a wholesale
move.

Thanks!

 

[Gary L. Chefetz [MVP]]

Thad:

The answer is yes, however you should repoint the SharePoint and OLAP cube
connections once you do this so that activity in the dev site does not
affect production data.