Skip to Main Content
  • Questions
  • Using Oracle SQLcl Project to deploy multiple schemas to environments with different schema names

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 27, 2026 - 3:26 pm UTC

Last updated: April 07, 2026 - 7:19 am UTC

Version: 25.4

You Asked

I am trying to setup a database project that has three or so schemas that are named the same for most of the deployed environments but are different for one deployment. For example local development through production would have schema names schema1, schema2, ... but for one set of deployed environments the schemas have been renamed and are out of my control, e.g., dba_schema_db1, dba_schema_db2, ...

What I want to know is if there is a built in way using SQLcl projects to alias the schemas so that they can be configured per environment without too much manual intervention.


and Connor said...

Better control over schemas comes in sqlcl 26.1

Here's an overview from Dan McGhan on that enhancement

https://danmcghan.hashnode.dev/schema-agnostic-staged-changesets-with-stage-substituteschemas