Question
Accenture
IN
Last activity: 22 Mar 2016 7:24 EDT
SQL file generation while Deployment
Hi All,
Some times when we are doing deployments in higher environments, PEGA application will generate SQL scripts dynamically.
How to prevent generation of SQL file while doing deployment.
Like do we need any special Read / Write permissions to the schema users which we are suing as default schema?
How can we solve this in case of ...
1. Single schema
2. Multi schema
In case If we are using Command line tools for Deployment ?
Can some one explain / provide some solution please?
Accepted Solution
Pegasystems Inc.
US
it should work as long as your connecting user has the privileges mentioned in the article.
Pegasystems Inc.
US
this link has good explanation: https://docs-previous.pega.com/restrict-database-schema-changes-setting-privileges
Updated: 22 Mar 2016 5:22 EDT
Greenfield AG
DE
Kevin,
will this work in case we are using command line tool?
Also, maybe there's a way to not generate schema updates with command line tool at all?