Ваші коментарі

Please:
1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar
2. 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.


Best regards,

Adam Mościcki

I have already answered in another ticket, so i will close this one.

Hello,


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.


Best regards,


Adam Mościcki

Hello,

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.

Hello


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.



Hello,


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

Hello,


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.



Hello,


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.