Copy a Project from one site to another

Take backup files of all three databases from the SQL server. for example, the Project database, Admin database and PIDreport database.

To take a backup of project databases open the Microsoft SQL Server management Studio. Right-click on the database and select Back Up.

The user has to select individual database to take the backup.

Select the database to be backed up. Select the path for the backup.

Click OK.

Copy the whole project folder and all three database .bak files to another site.

To restore all database backups to the client SQL server, right-click on the on the Database node and select Restore Database.

Select From device and provide the path for .bak file. Select the required database. Now select the database from the To database dropdown.