Schema based on environment

In one of my projects I need to access some test-data on an Oracle Database, which exists in a schema called "test". The source-table is then called test.customer.

When transferring the project to Production, I need to get my data from another schema called "crm". My source is then called "crm.customer". 

So far, I have not been able to find any great solution.

Are there any easy way to get around this issue? 



Please sign in to leave a comment.