Our software has been developed to support both MS SQL Server & ORACLE depending on the client using the software. With PowerServer 2020 we had both SQL Server and ORACLE set up in our configuration (Database Type section) so the output would support either DBMS. This solution had served us well for years.
Since beginning our migration to PS 2022 we have been focused on MSSQL, but we have noticed several syntax and object errors in the Errors tab after deployment. We've assumed this is the case since we have not setup an ORACLE DB on the Database page of the PS Project.
Upon inspection the Database page of the PS project, it has not been obvious how to utilize this to support both DBMS.
Can a PowerServer support both DBMS at the same time in the same project (possibly the DB connection profile) or do we need to create 2 separate projects? If it can be done within one project, can you provide some guidance on how this can be accomplished.