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

0
Not a bug

Reverse Engineering does not work

Rabbani Mohammed 6 years ago updated by Mariusz Zakrzewski 6 years ago 2

Hi,

I am trying to reverse engineer an existing database in MS SQL Server. I need to extend database capabilities and therefore need the existing model to start with. 

I am using the following connection string but getting an error. 

Can you please advise if this command is right? 

java -jar reverse-engineering.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://00.11.222.333\MMISQLE16,1433 -user xxx -password xxxxxx -o qa_db

The error message is as follows: 

No JDBC driver given. Using JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerD
river
Reverse engineering MS SQL Server database
Connecting to the database...
Exception in thread "main" com.vertabelo.reverse.ask: Unable to load JDBC driver
com.microsoft.sqlserver.jdbc.SQLServerDriver
at com.vertabelo.reverse.asl.b(:203)
at com.vertabelo.reverse.Main.main(:8253)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSer
verDriver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.vertabelo.reverse.asl.b(:201)
... 1 more

Appreciate your help.

0
Under review

my college doesn't issue any email addresses

abhisinghal2103 6 years ago updated by Mariusz Zakrzewski 6 years ago 1
Answer
Mariusz Zakrzewski 6 years ago

Hi,

I assume you want to use an academic account on Vertabelo. 


You can create an academic account providing a scan of your ID card. You do not have to provide an academic email address. In the registration form, next to the field 'ID card scan', select the image from your local disk. 


I hope that helps,

Mariusz Zakrzewski 

0
Completed

MySQL: decimal/double/float precision boundaries

Jadaw1n 11 years ago updated by rahul kumar 6 years ago 4
Display an error if a field has a larger decimal place value than the whole number part.

CREATE TABLE test (
something decimal(2,3) NOT NULL
)
MySQL said:
#1427 - For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'something'). 
+1

Editing shared database when trial period has expired?

Denis Zherdev 6 years ago 0

Good day. Could you help?


Can i edit shared (from other person) database if my trial period has expired?

0
Completed

Login Error

sinead 7 years ago updated by Rafał Strzaliński (Senior Engineer) 7 years ago 1

I purchased a course a while ago and I'm trying to log into my account to take it. However, every time I try "forgot my password" I get an error saying there's no account under my email. I have my invoice in my email inbox so I know I purchased it under the right email. Please let me know how to access my course. 

0
Not a bug

Allow column names with spaces with them by adding [] brackets to them in the SQL.

Shreya Kaushik 7 years ago updated by anonymous 7 years ago 1

I am using Microsoft SQL server as the database. The column names in the tables in my data model will have spaces. Currently the product continues to show me a warning against the column names saying that the name seems to be invalid. I even tried adding the square brackets my self in the column name itself but the warning still shows up.

0
Declined

how to export sql export as *.mdf file

Ard Shir 7 years ago updated by Adam Mościcki 7 years ago 1
Answer
Adam Mościcki 7 years ago

MDF is an SQL Server extension only. There is no way to export the model to MDF file in our tool.

+2
Under review

create schema via API

KenL 7 years ago updated 7 years ago 2

I think it would be great if you were able to create schemas via the API.  Think of it like photo reverse engineering, but, perhaps, a little more technical, able to capture more details like data types, and maybe even behaviors.

+4
Under review

Shortcut Ctrl+V does not work when trying to copy tables between documents

Mateusz Kamiński 7 years ago updated by Mariusz Zakrzewski 7 years ago 1

There was a possibility to copy tables between two schemas (documents) with shortcuts but now it's gone. I need to use Copy - Paste buttons on the panel that is a much slower way to copy content.