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

0
Не ошибка

Reverse Engineering does not work

Rabbani Mohammed 6 лет назад обновлен Mariusz Zakrzewski 6 лет назад 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
На рассмотрении

my college doesn't issue any email addresses

abhisinghal2103 6 лет назад обновлен Mariusz Zakrzewski 6 лет назад 1
Ответ
Mariusz Zakrzewski 6 лет назад

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
Завершен

MySQL: decimal/double/float precision boundaries

Jadaw1n 11 лет назад обновлен rahul kumar 6 лет назад 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 лет назад 0

Good day. Could you help?


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

0
Завершен

Login Error

sinead 7 лет назад обновлен Rafał Strzaliński (Senior Engineer) 7 лет назад 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
Не ошибка

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

Shreya Kaushik 7 лет назад обновлен anonymous 7 лет назад 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
Отклонен

how to export sql export as *.mdf file

Ard Shir 7 лет назад обновлен Adam Mościcki 7 лет назад 1
Ответ
Adam Mościcki 7 лет назад

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

+2
На рассмотрении

create schema via API

KenL 7 лет назад обновлен 7 лет назад 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
На рассмотрении

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

Mateusz Kamiński 7 лет назад обновлен Mariusz Zakrzewski 7 лет назад 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.

Сервис поддержки клиентов работает на платформе UserEcho