refreshing test from production

We are refreshing our database from production so the test environment is replica of production.

We export import the database and changed the storage path through PW admin in test environment. Is there anything else that we need to consider to have same projectwise as production?

we are seeing lot of workflow permissions are missing or they do not exist in production but shows up in test.

1) few security groups exist in test but they do not exist in production on folder level.

2) few exist in production but they were not copied to test

Do we need to do anything extra to copy the security otherwise why we have different groups between both environments?

Also, In test we are trying to remove the security group and it errors out "Cannot remove access control item"

Parents
  • when you say Export do you mean from ProjectWise or from SQL Server?

    To make sure we have an exact copy of the database we have our database group take the latest backup of the database from and restore that on the dev database server. This gives us an exact copy of the database (at least as it was at last backup, hopefully just the night before) and it lets us test our backups to make sure they are working correctly.

    we shut off the dev integration server while the restore is going on. after the restore is brought online I modify all the hostnames for the storage areas to servername that doesn't exist. Previously I would do this in SQL Server Studio, but i'll probably use powershell in the future.  also need to modify indexing and thumbnails so they aren't submitted to the production indexing server.

     

Reply
  • when you say Export do you mean from ProjectWise or from SQL Server?

    To make sure we have an exact copy of the database we have our database group take the latest backup of the database from and restore that on the dev database server. This gives us an exact copy of the database (at least as it was at last backup, hopefully just the night before) and it lets us test our backups to make sure they are working correctly.

    we shut off the dev integration server while the restore is going on. after the restore is brought online I modify all the hostnames for the storage areas to servername that doesn't exist. Previously I would do this in SQL Server Studio, but i'll probably use powershell in the future.  also need to modify indexing and thumbnails so they aren't submitted to the production indexing server.

     

Children