Question

Importing SQL server DB to Domain Model

0

Hi guys, We have a legacy application that we would like to modernise, it has an existing database in SQL server recently upgraded to SQL server 2014. My question is if there is a way we could import the schema into a domain model. I could connect to the database by setting the connection details in the project settings but i cant find out how to import the schema to a domain model. I have also tried the databasereplication module but cant really figure it out, as its my first time with mendix. Thank you for your help.

asked 2016-01-06

Bart Kappel

3 answers

Marc Lehane · Answer 1 · 2016-01-06

You could also convert the Schema to an XSD. You can do it through programming or using a utility like XMLSpy.

Mitchel Mol · Answer 2 · 2016-01-06

The database replication module is used for importing the data from another database, not the schema.

You might want to check out the open platform functions which are part of Mendix 6+ it might help you further with importing your legacy schema into Mendix.

Andrej Koelewijn · Answer 3 · 2016-01-07

What is your goal, do you need the data to remain in your existing scheme in your existing database, or would a one time migration to an new Mendix database suffice?

The first option is currently not supported. The second could be build using the Mendix SDK, but easiest is probably to manually create a new domain model in the Mendix modeler. If you run on-premises you could deploy on the existing database in a new scheme (new set of tables in the same database) and copy the data using some SQL scripts. For copying the data you can also use the database replication module.