Migrating objects from an Open Source installation to DataLens On-premises

We offer a solution for migrating objects from an Open Source installation to On-premises. You can migrate the following objects: connections, datasets, charts, dashboards, collections and workbooks.

To perform a migration:

In the directory containing the DataLens Open Source repository, run the script to create a dump of all open source installation entities. The dump file will be created at ./backup/pg_us_open_source_db.dump.
Update your On-premises installation to version 25.3.0 or higher.

Note

Before upgrading, create a backup copy of the .env environment variables configuration file. If you loose this file, you will need to recover the system manually.

To update your version, unpack the archive to the directory containing the On-premises installation repository by replacing the files and run the initialization command:
```
./init.sh
```
Move the dump file from the Open Source installation to the On-premises installation root directory. For example, to /home/user/datalens-enterprise/pg_us_open_source_db.dump.
Start the object restore script from the OpenSource installation dump:
```
./help/restore-entries-from-opensource.sh ./pg_us_open_source_db.dump
```
Where ./pg_us_open_source_db.dump is the dump file path.

After the script is executed, the object structure will be automatically restored and access permissions will be edited for correct operation of the new entities access permissions dialog.