1
226

Written by

Rahul Raj
Follow
Question Rahul Raj · Oct 28, 2024

Exporting Cache data along with the table schema

#Caché #Databases #Data Import and Export

Hi! I am trying to export Cache data to my SQL database and am trying to export the schema as well.

The Data Export wizard on the Management Portal only allows me to export the data but not the schema. Is there anyway to get the schema exported as well?

Product version: Caché 2016.1
$ZV: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2016.1.2 (Build 206U) Mon Jul 25 2016 16:47:58 EDT
Discussion (4)3
Log in or sign up to continue

Comments

Rahul Raj  Oct 28, 2024 to José Pereira

Hi José,

Thank you for your response. I went through the Export() method of the %SYSTEM.SQL class but it only exports User definitions, Role definitions, and/or Privileges.
I actually want to export the Table/View definitions in the schema and generate the DDL of their creation.

Thank you!

0
José Pereira  Oct 29, 2024 to Rahul Raj

Interesting... The method exports User definitions, Role definitions, and Privileges by default, so it's kind working.

Did you tried to pass the value "*" to parameters Schema and Table to test it on all schemas and table into your namespace? Also make sure you are in the correct namespace.

0