Question

Database schema generation with Mendix in existing database

5

Is it possible to generate a database schema with Mendix in an existing Oracle database which hosts already several other database schemas e.g. BaaN.

asked 2009-12-29

Pieter Verkroost

2 answers

Alexander Willemsen · Answer 1 · 2010-01-06

I've got no experience using Oracle, but conceptually I see no problems. Just make sure you use a unique schema for your Mendix data, to prevent any interference with the existing schema's.

Jonathan Veldhuizen · Answer 2 · 2010-01-06

In Oracle, each user has its own schema. When you create a specific user for the Mendix application, I think it is not a problem. However, make sure only Mendix connects to the Oracle database with the credentials of this specific user. Mendix removes all non-Mendix tables within its own user schema.

Please note that in SQL Server and PostgreSQL, a Mendix application must have its own database. Mendix removes all non-Mendix tables within this database, regardless of their schema.