We need to migrate a mssql database to a postgresql database, after some research online i've found out that this is not a standard process. There is a manual on how to do this on the postgresql site or even a (paid) dbconverter that does this for you. So, does anybody have any experience with migrating mssql to postgresql? Are there known bugs/difficulties with migrating this data that are mendix specific? Is it better to use 3rd party software for this or would it be better to write a custom script for this (e.g. due to the way mendix builds the database) Any help/tips would be much appreciated.
Jelle van Vliet
Mendix databases are pretty specific with some meta information stored in the database, so I don't think you'll be able to do this in a reasonable amount of time by just converting the database. I would look at options like the database importer module in the App Store or some other way of importing the data into your Mendix application.