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 6 years ago • updated by Adam Mościcki 6 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.)
Customer support service by UserEcho
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
Yes, there is a room for improvement. I will discuss this with my team.
Hope this helps,