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

0
Not a bug

Reverse Engineering does not work

Rabbani Mohammed fa 6 anys updated by Mariusz Zakrzewski fa 6 anys 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 fa 6 anys updated by Mariusz Zakrzewski fa 6 anys 1
Answer
Mariusz Zakrzewski fa 6 anys

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
Completat

MySQL: decimal/double/float precision boundaries

Jadaw1n fa 11 anys updated by rahul kumar fa 6 anys 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 fa 6 anys 0

Good day. Could you help?


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

0
Completat

Login Error

sinead fa 7 anys updated by Rafał Strzaliński (Senior Engineer) fa 7 anys 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 fa 7 anys updated by anonymous fa 7 anys 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 fa 7 anys updated by Adam Mościcki fa 7 anys 1
Answer
Adam Mościcki fa 7 anys

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 fa 7 anys actualitzat fa 7 anys 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 fa 7 anys updated by Mariusz Zakrzewski fa 7 anys 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.