Your feedback is highly appreciated! Let's make Vertabelo even better.

  1. Foorum: Vertabelo
0

Functions

Jussi Kinnula 7 aastat tagasi • uuendaja Susan Mayer 5 aastat tagasi • 0

It would be nice to define functions as separate blocks in the diagram. Now I'm using "Additional SQL scripts" section in relevant tables to define functions, but since functions can consist of many views or tables it would be nice to separate them.

0
Answered

Vertabelo Reverse Engineering Tool doesn't extract databases

Mariusz M 10 aastat tagasi • uuendaja kate Winfield 5 aastat tagasi • 9
Why Vertabelo Reverse Engineering Tool extracts tables only from master system database in MSSQL Express?
0
Answered

does not recognize my email

jeffreyjohnson11 5 aastat tagasi • uuendaja Adam Mościcki 5 aastat tagasi • 1

I created an account a year ago for the beginner SQL course. I tried to go back to the course today but Vertabelo is claiming that the email associated with my account does not exist. I have the receipt from my purchase on my email account. How would I go about recovering my account? Thank you. 

0
Ülevaatamisel

[Postgres] Constraint added automatically NOT DEFERRABLE INITIALLY IMMEDIATE

yun lee 7 aastat tagasi • uuendaja Adam Mościcki 5 aastat tagasi • 3

By default is NOT DEFERRABLE and if it is NOT DEFERRABLE it is also IMMEDIATE, right?


Should I use those even it is set by default? Or it does imply something other?


Because the SQL generates with this Keyword in anyplace. and I'm not sure about the implications of all.


0
Fixed

SQLite Autoincrement

Javier Tejedor 9 aastat tagasi • uuendaja hepeyowa 5 aastat tagasi • 3

Hello, I have exported the SQL for a SQLite Database. In the tables, I have PRIMARY_KEY and AUTOINCREMENT.


CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL AUTOINCREMENT,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

Using this format, SQLite is throwing an error due the AUTOINCREMENT is not declared as PRIMARY KEY yet (it is being done in the CONSTRAINT). I am using the java sqlite-jdbc-3.8.11.2.jar driver from org.xerial


SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)


A possible correct syntax (regarding to the SQLite documentation https://www.sqlite.org/autoinc.html ) for the previous example would be:


CREATE TABLE CSS_AT_RULES (	
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT,	
    css_version varchar(10) NOT NULL,	
    syntax_id integer NOT NULL
);

Could you please confirm if I am right?


Regards,

Javier.

Vasta
anonymous 9 aastat tagasi

Hello,

Yes, it is a bug.
I think, the correct syntax is (as sqlite's faq mentions https://www.sqlite.org/faq.html#q1):

CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

If column has type 'integer' and 'primary key' then has also 'autoincrement'.

In this case, the fastes solution is to unset an autoincrement option.


I hope this helps.


0
Tagasi lükatud

Is posible to share tables between diagrams?

Toni Aracil Sobrino 6 aastat tagasi • uuendaja Adam Mościcki 6 aastat tagasi • 1

I need to share tables between diagrams. Because I need a change in one entity be replicated to table shared table with other diagram. Is that possible?


Thanks.

0
Ülevaatamisel

Please add adjustable rules for all of us anal-retentive people

Eric Norcross 8 aastat tagasi • uuendaja Joana PhotoshopSupply 6 aastat tagasi • 3

I spend waaaaay too much time trying to align and make boxes the same size

0
Ülevaatamisel

how to use the reverse Reverse engineering to? 14?

mo aarab 8 aastat tagasi • uuendaja Rafał Strzaliński (Senior Engineer) 6 aastat tagasi • 4

is it possible to get an example to SQL Server 14? I'm don't know anything of java

Vasta
Adam Mościcki 8 aastat tagasi

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

0
Answered

Getting error trying to use reverse engineering tool

Kent Graziano 9 aastat tagasi • uuendaja Yomiyu Malifu 6 aastat tagasi • 11
I am using this command line on Windows 8:
java -cp .;reverse-engineering-1_6_9; com.vertabelo.reverse.Main -url jdbc:oracle:thin:@//localhost:1521/xe -user dv -password xx -o dv_demo

But get the error: Could not find or load main class com.vertabelo.reverse.Main
I am running in my \vertabelo directory. I downloaded the .jar file to that folder.

I am very bad at command line so have no idea how to fix this.


Customer support service by UserEcho