Creating a test environment from a production repository

The following article will cover PostgresSQL, SQL, And Oracle databases.


For Postgres, you will need to confirm your Pyramid version on the Production environment by clicking on your initials on the tab at the top right-hand side of the screen as shown below. 

We can see its Pyramid version 2020.11.030, in this case, we will run the installer version 2020.11.030 in our test environment.

We will choose New internal repository or new remote repository > PostgresSQL:


We will finish the installation and go back to the production environment to make a backup for the repository.

Run the following command to make a backup in our production server:

"C:\Program Files\Pyramid\postgres\pgsql\bin\pg_dump.exe" -U pyramid  -h localhost -p 12130 -F t  -f  "C:\backup\pyramidDbBackup.tar"  pyramidg2

The default password for the DB is: pyramid

Now copy the file into our Test environment and run the following command in the CMD to restore the database:

"C:\Program Files\Pyramid\postgres\pgsql\bin\pg_restore.exe" --clean -h localhost -p 12130 -U pyramid -d pyramidg2 C:\backup\pyramidDbBackup.tar

After restoring has been complete we will need to truncate the server table by running the file attached, or by connecting to the database via 3rd party app.

After truncating the tables restart all Pyramid services, wait a few minutes, and try to log in.

NOTE: you will need to change the data source so it won't point into production repositories.

If you are using IMDB you will need to copy the IMDATA folder from the production server

Now make sure that everything is working fine, and all the reports can be open with no errors, and you can install under the test environment our latest version.

MS SQL Server and Oracle

For SQL and Oracle database you will need the same Pyramid version or higher version.
for example, if you have Pyramid 2020.05.30 you can run installer build 2020.11.030.

The first step is to create a repository backup from the production environment and load it into your SQL or Oracle test environment.

After you have loaded the repository into your SQL or Oracle test environment you can run our installer and choose "Reuse Pre-existing Repository" > Microsoft SQL Server Or Oracle.



Point Pyramid to your SQL database:


Point Pyramid to your Oracle database:



And finish the installation.

Log in to your test environment and make sure you can open the reports.

Make sure to stop all the models and stop all publications.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 5 mths agoLast active
  • 86Views
  • 2 Following