For a customer we have three environments:
- Development
- QA
- Production
In the workbench we use a lot of QueryTemplates with SQL queries to the specific database (D,QA or P). The prefix of the tables in the databases are depending on the environment.
e.g.
- for Development the prefix of each table is SAPMIDDB,
- for Production the prefix is SAPMIPDB
If I export a Workbench project from Development to Production I have to change the prefix of the tables in all QueryTemplates manually.
My question: Is there a way to use some kind of parameter (maybe in the SharedProperties.mem) so I only have to change this parameter once?