Including SQL Tables when deploying between productions

Question

Hi everyone.

I have a use case where I'm using embedded SQL within a Business Process to interact with a SQL table. However, when it comes to deployment into our production, the table wont form part of the deployment package created from the production.

Beyond manually creating the table on the production system, is there a standard way of ensuring that a table needed for a class is created during deployment?

Product version: IRIS 2022.1

Discussion (2)2

John Murray · Jan 16

You could use the technique I described in https://community.intersystems.com/post/class-projections-and-projection...

0 0

Evgeny Shvarov · Jan 16

Hi @Julian Matthews !

I'd suggest using IPM modules for deployment where you suggest what is included in the module. Here is an example of module with simple Interoperability production.

0 0

Including SQL Tables when deploying between productions

Social networks

InterSystems resources