Hello,
I am just curious to as how views will now work in packages for Creatio.
With some environments running SQL, and some environments running Postgres. How will it work when having a package with a SQL view. Will it be migrated over correctly, or is there another place to put Postgres views?
Thank you in advance
Sincerely,
Tyler Rainey
Like
Hello.
It is possible to specify the script type. When creating a new one, it is possible to specify its dialect in the SQL scripts tab. By default it is DBMS. The default value defines the DB provider, if it s Postgre - the field will be populated in Postgre, if it is MS SQL - then it will be populated in MS SQL.
Thus, to make sure your views work fine, it is necessary to create scripts for particular database separately, either for MS SQL, Postgre or Oracle.
For example, the application has such scripts as CreateVwSiteEventMSSQL, CreateVwSiteEventOracle, CreateVwSiteEventPostgreSql
Regards,
Dean