Exporting Cache data along with the table schema
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
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
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!
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.
I found the answer to my question here: https://community.intersystems.com/post/export-ddl-cach%C3%A9-class