Including SQL Tables when deploying between productions
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
You could use the technique I described in https://community.intersystems.com/post/class-projections-and-projection...
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.