Import Cache class definitions into SQL Server

Question

Question

Dan Pahnke · Jun 23, 2021

A sudden and short delivery date task has come into being. What is the fastest way to recreate a Cache 2018 application schema definition in SQL server?

Thanks in advance,

Dan

Product version: Caché 2018.1

Discussion (7)2

Log in or sign up to continue

Eduard Lebedyuk · Jun 23, 2021

First, transfer your schema via $SYSTEM.SQL.Schema.ExportDDL.

After that transfer data via CSV.

0 0

score 0 · Answer 1 · 2021-06-23T14:23:08-04:00

Eduard Lebedyuk · Jun 23, 2021

A sudden and short delivery date task has come into being

Don't they always.

0 0

score 0 · Answer 2 · 2021-06-23T14:40:11-04:00

That would be funny if it weren't so true.

This one is very high profile and joins the list of demands competing for resources.

score 0 · Answer 3 · 2021-06-23T17:21:45-04:00

Thanks Eduard. I passed the info along to the person with the task. I'll let you know how well it works for the goal.

Plus, for the task at hand, only the data definitions are necessary, not the data.

score 0 · Answer 4 · 2021-06-25T07:07:47-04:00

Hi Eduard,

I got a call from the person carrying out the task last night. ExportDDL isn't available in the 2018 Cache version being used. We ended up extracting the DDL though via the external WinSQL software.

Thanks again.

score 0 · Answer 5 · 2021-06-25T14:57:09-04:00

Alexander Koblov Jun 25, 2021 to Dan Pahnke

It’s $System.SQL.Export before InterSystems IRIS 2021.1

0 0

score 0 · Answer 6 · 2021-06-25T15:01:34-04:00

Dan Pahnke Jun 25, 2021 to Alexander Koblov

Good afternoon Alexander,

We tried that. It didn't yield the Create Table ddl.

Dan

0 0