Exporting Cache data along with the table schema

Question

Question

Rahul Raj · Oct 28, 2024

#Databases #Data Import and Export #Caché

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

Rahul Raj · Nov 4, 2024

I found the answer to my question here: https://community.intersystems.com/post/export-ddl-cach%C3%A9-class

0 0

score 0 · Answer 1 · 2024-10-28T11:27:06-04:00

Hi!

I don't know how to achieve this by using Portal directly, but you can export SQL schema using this method in Cache.

Just for note, in IRIS you also have this another option.

HTH

score 0 · Answer 2 · 2024-10-28T11:51:20-04:00

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!

score 0 · Answer 3 · 2024-10-29T10:39:25-04:00

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.