You can translate the question and the replies:

Import/Export objects from one environment to other environment

Hi Experts, Using export/Import of .vql we migrate from dev to QA. This will be a tedious task for following scenarios, I suspect I am not doing correct way, can you pls provide if any alternate way available? 1. When we are migrating selective tables (for entire folder it is easy to export but selective tables is not possible with multiple selection of tables), Ex: I need to migrate 10 tables so I end up generating 10 export scripts and combine them for import –Do we have any option to selectively do a 10 table export ? 2. As mentioned in # 1, that process for umbrella only, if I have those tables available in other user vdb’s, then I have to generate 10 different scripts for vdb specific. – do we have any capability that if I export a script from user vdb that generate required umbrella object as well(like export dependent umbrella objects as well) ? Thanks in advace!!
importing multiple vqls mass exports
user
23-10-2017 11:43:13 -0400
code

3 Answers

Hi, In Order to export/import multiple views together, I would do the following * Create a new folder in Virtual DataPort Administration Tool by clicking on File>New>Folder. * Drag and drop the required views into that folder. * Export the folder along with its dependencies by right-clicking on New>Folder > Export under Element Tree and enable ‘Export Dependencies’ in the Export Database window. * Then import the VQL of the folder along with dependencies into the new environment. In Virtual DataPort users should have 'admin' privileges over the Virtual databases created by other users to export the VQL with dependency objects. To know more about exporting and importing in Virtual DataPort, you could refer the [Exporting and Importing Server metadata](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/exporting_and_importing_the_server_metadata/exporting_and_importing_the_server_metadata#exporting-and-importing-the-server-metadata) of the Virtual DataPort Administration Guide. Hope this helps you!
Denodo Team
24-10-2017 09:45:09 -0400
code
Thank you for your response! 1. in my case objects are related to diffrent business groups so i can't be have them in one folder, if I prctice this approch it will become one folder a day. so Pls advice ? 2. when I export object from particular vdb with "Eport Dependencies" option it doesn't provide umbrella object code for it. is it something worng I am doing ? or Dependencies is limited to vdb level only(not includeing umbrella) ? thnaks!
user
 Edited on: 05-03-2019 14:54:19 -0500
Hi, In Denodo platform you could import the views into different environments by exporting the views from a single VQL file or from a Repository. For your scenario, as objects are from different business groups you could only export views by generating individual export scripts for each views. When you use Export dependencies option and the type is chosen as 'View', Virtual DataPort would export the elements including dependent views, types, data sources and folders. Have a look at the [Exporting the Server Metadata section](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/exporting_and_importing_the_server_metadata/exporting_the_server_metadata/exporting_the_server_metadata#exporting-the-server-metadata) of the Virtual DataPort Administration Tool for more information on exporting views with dependencies. Hope this helps you!
Denodo Team
01-11-2017 08:49:50 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here