Please:1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar2. Download jdbc driver https://www.microsoft.com/en-us/download/details.aspx?id=11774 (exe file should install jar somewhere)3. In the download folder do:
java -cp .:reverse-engineering-1_6_12.jar:sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] -user USERNAME -password PASSWORD -o OUTPUT_FILENAME
I hope this helps.
I have already answered in another ticket, so i will close this one.
I have answered for privert ticket, but this might be helpful to others.
The reverse engineering tool imports tables from database directly.
Import from SQL script can be done on the 'new model' page.
To make it work, please comment out/remove lines at the end of the sql file like:
'ALTER TABLE xxx MODIFY yyy int(11) NOT NULL AUTO_INCREMENT;'
I have removed those lines from your sql and it worked. Our sql2vertabelo tool has trouble in parsing such statetments.
Also I have shared to you a model which i got. Feel free to unshare me.
We provide a way to embed model on a website. An article which explain how to do it: https://www.vertabelo.com/blog/vertabelo-news/how-to-embed-your-database-model-into-a-website Is this what you need? If not please tell what is missing.
You can import an existing database into Vertabelo with help of our Reverse Engineering tool. An article about it: http://www.vertabelo.com/blog/documentation/reverse-engineering
You can also import an sql file when creating new model, screenshot:
I hope this helps
Oracle 11g does not support ON UPDATE clause. Please see documentation on REFERENCES: https://docs.oracle.com/cd/B28359_01/server.111/b28286/clauses002.htm#CJAIHHGC
You can emulate this behaviour, tutorial: http://www.dba-oracle.com/oracle_tips_cascade_update.htm
We don't disable 'on update' select for Oracle in UI so it might be confusing...
Note: If you choose another DB engine (for example Postgres), Vertabelo will generate ON UPDATE clause.
This is not possible.
I will move this topic to the idea category. Let's wait for comments and upvotes to see how important it is for others.
Customer support service by UserEcho