You can translate the question and the replies:

How to create 2 different environments in one Denodo Platform installed?

Currently, I have a virtual database named "xyz" in Denodo 7.0. As per my project's requirement - I would like to replicate the same virtual database with a new name "xyz_staging" as I have only ONE Denodo platform installed. And, I would like to rename the exisiting database from "xyz" to "xyz_dev". All datasources are connected to SQL Server via Microsoft SQL Server (MS Driver). xyz_dev should point to DEV SQL Server (which is currently pointing) And newly created xyz_staging should point to Staging SQL server. I have approximately 30 datasources. Do I need to change the connection string (Database URI) of all the datasources individually or I can change it in "environment specific properties"? Please provide guidelines on how to achieve this. Please let me know what else do I need to take into account while doing this.
user
10-11-2018 14:32:36 -0500

1 Answer

Hi, Here’s a way to accomplish what you need: 1. You can manually generate “xyz_dev” and “xyz_staging” as empty virtual databases. 2. Export the VQL from “xyz” with properties and unchecking the option "Create Virtual Database". This is important as it allows the VQL to be imported into any VDB. 3. Maintain two copies of the properties files, one for “xyz_dev” and one for “xyz_staging”. Edit the “xyz_staging.properties” file and update the Database URIs as needed. 4. Then run an import twice. Use the same VQL file, but different properties files, and different target VDB: one for the “xyz_dev” and the other for “xyz_staging”. 5. Remove the old VDB “xyx”. Note that in the future if you end up using two separate Denodo 7.0 installs (eg: on different server machines), you can use the Denodo Solution Manager for managing migrations of databases from one environment to another. More info on exporting VDP server metadata can be found here: [Exporting the Server Metadata](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/exporting_and_importing_the_server_metadata/exporting_the_server_metadata/exporting_the_server_metadata#exporting-the-server-metadata) Hope this helps!
Denodo Team
12-11-2018 19:48:32 -0500
You must sign in to add an answer. If you do not have an account, you can register here