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

0
Ikke en bug

Reverse Engineering does not work

Rabbani Mohammed 6 år siden opdateret af Mariusz Zakrzewski 6 år siden 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 vurdering

my college doesn't issue any email addresses

abhisinghal2103 6 år siden opdateret af Mariusz Zakrzewski 6 år siden 1
Svar
Mariusz Zakrzewski 6 år siden

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
Færdig

MySQL: decimal/double/float precision boundaries

Jadaw1n 11 år siden opdateret af rahul kumar 6 år siden 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 år siden 0

Good day. Could you help?


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

0
Færdig

Login Error

sinead 7 år siden opdateret af Rafał Strzaliński (Senior Engineer) 7 år siden 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
Ikke en bug

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

Shreya Kaushik 7 år siden opdateret af anonymous 7 år siden 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
Afvist

how to export sql export as *.mdf file

Ard Shir 7 år siden opdateret af Adam Mościcki 7 år siden 1
Svar
Adam Mościcki 7 år siden

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

+2
Under vurdering

create schema via API

KenL 7 år siden opdateret 7 år siden 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 vurdering

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

Mateusz Kamiński 7 år siden opdateret af Mariusz Zakrzewski 7 år siden 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.

Kundesupport af UserEcho