You can translate the question and the replies:

Derived View problem in Migration

I migrated my databases from Denodo 7.0 to Denodo 8.0 and in that I lost my Derived View from the database. I normally get vql and properties files from Denodo 7.0 and after getting started I received this problem. Please get me for this as soon as possible. Thank You
user
29-10-2020 14:07:51 -0400

1 Answer

Hi, I was able to successfully migrate all views from Denodo Platform 7.0 to Denodo Platform 8.0, by executing the below command in the VQL shell in Denodo Platform 7.0 by login as an administrator account. ``` SET 'com.denodo.exportMigrationCompatibility' = 'true'; SET 'com.denodo.vdb.catalog.exportOnlyResources' = 'true'; ``` To export metadata, I have utilized the export script available in the <DENODO_HOME>/bin. Then I have imported that metadata file using the import script located at <DENODO_HOME>/bin in the Denodo Platform 8.0. To get more information related to migration steps, you could refer to the following documents, * [Export the Settings and Metadata of the Current Installation](https://community.denodo.com/docs/html/browse/8.0/platform/upgrade/export_the_metadata_of_the_current_installation#export-the-settings-and-metadata-of-the-current-installation). * [Import Settings and Metadata into the New Installation](https://community.denodo.com/docs/html/browse/8.0/platform/upgrade/import_the_metadata_to_the_new_installation#import-settings-and-metadata-in-to-the-new-installation). Hope this helps!
Denodo Team
30-10-2020 03:52:37 -0400
You must sign in to add an answer. If you do not have an account, you can register here