Hello
This tool is exactly what I need for my current scenario, but I ran into the below issue. I am on the cloud hosted license.
I generated the 'create view' script for SQL Server, but when I tried to compile on the OutSystems database, I got an 'Access denied' error on the database. I opened a support ticket with OutSystems, and the response was that the permission I require to create database objects is not supported by the platform - https://success.outsystems.com/Support/Enterprise_Customers/Maintenance_and_Operations/Access_the_database_of_your_OutSystems_Cloud#What_permissions_are_granted
Are you aware of this issue, or is there a way around this?
Best regards
Leigh
Unfortunately there is no way to get around this. OutSystems cloud prevents the user you are running as from being able to change the schemas at all. This tool is strictly for on-prem use (or your own AWS, Azure, etc. instance) because of that.
J.Ja
Hi Justin.
Thank you for the response.