You can translate the question and the replies:

How Move table from one database to other database through VQL Shell?

Suppose i have x and y database folders. there are subfolders (A,B) under X and Y having subfolders(C,D). i want to move views from X(A) to Y(D). Please share VQL command and help me its needful.
user
06-08-2021 02:25:40 -0400
code

5 Answers

Hi, You can export the View definitions for folder A from Database x to VQL file , change the folder name in VQL and import into Database Y
user
06-08-2021 11:04:26 -0400
Please share VQL command for export views?
user
06-08-2021 11:17:47 -0400
Hi, In Denodo, I am able to export the VQL of a specific view using the command DESC VQL VIEW <VIEW_NAME>. For an overview of using VQL to export data, please check out the [Exporting Metadata](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/describing_catalog_elements/exporting_metadata/exporting_metadata) section of the Virtual DataPort VQL Guide. To get the VQL of a particular view, I can also double click that view and then copy the commands found in the VQL tab. Once I have the VQL of a view I can import the views into the other database by running those copied VQL commands after making the necessary changes to the folder names and database names among other things. Hope this helps!
Denodo Team
09-08-2021 16:20:31 -0400
code
Please note DESC VQL VIEW <VIEW_NAME> only work at view level. So there's no direct command to export VQL VIEW at folder level.
user
10-08-2021 08:23:00 -0400
Hi, In Denodo, I can get the VQL for a certain folder by running the command below with the correct folder parameters. `DESC VQL FOLDER <path:literal> [ ( <DESC FOLDER parameter> [, <DESC FOLDER parameter>]*) ]` For more information on this command please check out the [Describing Catalog Elements](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/describing_catalog_elements/describing_catalog_elements#describing-catalog-elements) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
13-09-2021 18:37:04 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here