0
Under review

Importing existing Postgres fails with "SQL import failed. Either our parser is not perfect or your SQL syntax is invalid." No other info!

Gabriel Underwood 7 years ago updated by Adam Mościcki 7 years ago 1

I'm trying to create a Vertabelo model from an existing Postgres schema. It looks like you can't create a model from a Postgres database connection, so I exported my Postgres using pg_dump to SQL text and tried Vertabelo "Create New Model" "From SQL".

I get an error message: "SQL import failed. Either our parser is not perfect or your SQL syntax is invalid." with no other info.


1) What's the best way to make a Vertabelo model from an existing Postgres database?


2) The SQL import should give a more useful error message. The lack of useful error info means I don't know what I could do to fix it (e.g, play with Postgres pg_dump export options to get SQL that Vertabelo can read.)



Under review

Hello,


It looks like you can't create a model from a Postgres database connection,
1) What's the best way to make a Vertabelo model from an existing Postgres database?

There is a way to do that. We have created a standalone reverse-engineering tool, which connects to the database and produces XML model.

Then that XML can be uploaded to Vertabelo.

Comprehensive instruction: http://www.vertabelo.com/blog/documentation/reverse-engineering


2) The SQL import should give a more useful error message. The lack of useful error info means I don't know what I could do to fix it (e.g, play with Postgres pg_dump export options to get SQL that Vertabelo can read.)

Yes, there is a room for improvement. I will discuss this with my team.


Hope this helps,

Adam Mościcki