Compare database structure with application domain and generate SQL script for create missing objects and alter modified objects. Can optionally execute generated SQL scripts (for local server only).
WARNING: do not run this command on production database in automatic mode - always review SQL script manually before run
Usage from a command line:
ubcli generateDDL -?Usage from code:
const DDLGenerator = require('@unitybase/ubcli/generateDDL')
var options = {
host: 'http://localhost:888',
user: "admin",
pwd: "admin",
out: process.cwd(),
autorun: true,
optimistic: false
}
DDLGenerator(options)