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

0
Pas un bug

Reverse Engineering does not work

Rabbani Mohammed il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 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
À l'étude

my college doesn't issue any email addresses

abhisinghal2103 il y a 6 ans mis à jour par Mariusz Zakrzewski il y a 6 ans 1
Solution
Mariusz Zakrzewski il y a 6 ans

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
Terminé

MySQL: decimal/double/float precision boundaries

Jadaw1n il y a 11 ans mis à jour par rahul kumar il y a 6 ans 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 il y a 6 ans 0

Good day. Could you help?


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

0
Terminé

Login Error

sinead il y a 7 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 7 ans 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
Pas un bug

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

Shreya Kaushik il y a 7 ans mis à jour par anonymous il y a 7 ans 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
Écarté

how to export sql export as *.mdf file

Ard Shir il y a 7 ans mis à jour par Adam Mościcki il y a 7 ans 1
Solution
Adam Mościcki il y a 7 ans

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

+2
À l'étude

create schema via API

KenL il y a 7 ans mis à jour il y a 7 ans 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
À l'étude

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

Mateusz Kamiński il y a 7 ans mis à jour par Mariusz Zakrzewski il y a 7 ans 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.