PostgreSQL to MSSQL

0
Our implementation was created with a PostgreSQL database, but it really should have been created using an MS SQL Server database. A couple questions about this: 1. It does not seem clear, but is it possible to use SQL Server Management Studio to view/edit data in a Mendix hosted MS SQL Server database? If so, how? 2. Is it possible to migrate our database from PostgreSQL to MS SQL? 3. If #2 is not possible, what tools are used to view/edit data in the PostgreSQL Mendix hosted database? Thanks,
asked
1 answers
2

Hi Michael,

Why do you want your database to be MS SQL?

  1. In the Mendix Cloud, apps always use PostgreSQL. Mendix does support MS SQL for installations hosted in your cloud or on your own servers.
  2. Yes: https://docs.mendix.com/howtogeneral/tips/migrating-your-mendix-database
answered