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.
As http://www.vertabelo.com/blog/documentation/vertabelo-in-house-installation-guide mentions, the installation process asks for an application URL.
In case of AWS it will be the address of AWS server (most likely IP or domain address), so it won't be a localhost.
There is no way to that easily right now. You can generate 'drop' script and 'creation' script, but it works only for fresh databases and requires deletion of data in the table.
We've implemented a migration tool which can do that, but we are still testing it. We are going to release it in about 2 weeks.
I hope this helps.
You can install our tool on AWS (or on any private server). More details can be found here: In house license
We are working on integration with Azure platform right now . Integration with AWS is our second goal and I am not able to tell you when it happen.
If you have any questions, don't hesitate to contact us.
PS. We don't provide chat support.
Сервис поддержки клиентов работает на платформе UserEcho