![](https://cdn.userecho.com/characters/77.png?1)
Vertabelo Reverse Engineering Tool doesn't extract databases
Vasta
![](https://cdn.userecho.com/characters/97.png?1)
jdbc:sqlserver://192.168.0.5:1433;databaseName=my_database
![](https://cdn.userecho.com/characters/77.png?1)
![](https://cdn.userecho.com/characters/73.png?1)
I just downloaded the reverse engineering tool and I am trying to connect to a sql server. If I use jdbc connection string as jdbc:sqlserver://ipaddress:port;databaseName=mydatabase-name -user sa -password _pwd_ I get Login failed for user '' error. The error goes away if I take out the databaseName property, but export happens for the default database which I don't want( so user id and password are accurate and user is active). Even if I add user and password properties before or after databaseName property value, I still get the same error. Any ideas? (JRE8 version). Could the issue be with the name of database containing a hyphen?
![](https://cdn.userecho.com/characters/77.png?1)
Hi,
Can you verify that the user you are using has permissions to your database ("mydatabase-name")?
Perhaps, it has only permissions to your default database.
Parsing works properly, so hyphen in the database name should not cause problems.
Regards,
Mariusz Zakrzewski
![](https://cdn.userecho.com/characters/83.png?1)
Thanks Mariusz for the reply. Yes. the id has access to the database. I am able to run queries on the schema tables as well as "sys." tables without any issues. When I put the database name, the user id in the error is coming blanks and not the user id I am passing against the -user argument
![](https://cdn.userecho.com/characters/77.png?1)
Probably your shell interprets semicolon as a new instruction.
I was able to reproduce similar behavior.
$ java -cp .:reverse-engineering.jar:mssql-jdbc-7.2.1.jre8.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://127.0.0.1:1433;databaseName=database-one -user user1 -password 'xxxxxxxxxx' -o out_reverse Exception in thread "main" com.vertabelo.reverse.asj: Error: missing output file. Specify -o option. at com.vertabelo.reverse.Main.main(:5516) No command '-user' found, did you mean: Command 'fuser' from package 'psmisc' (main) Command 'kuser' from package 'kuser' (universe) -user: command not found
But with
$ java -cp .:reverse-engineering.jar:mssql-jdbc-7.2.1.jre8.jar com.vertabelo.reverse.Main -url 'jdbc:sqlserver://127.0.0.1:1433;databaseName=database1' -user user1 -password 'xxxxxxxxxxx' -o out_reverse No JDBC driver given. Using JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver Reverse engineering MS SQL Server database Connecting to the database... Database: Microsoft SQL Server 14.00.3048 Extracting table information Extracting view information Extracting reference information Extracting sequence information Preparing xml... Preparing xml done. Drawing the graph Found: 0 table(s) 0 view(s) 0 reference(s)
Please, try again with quotation marks.
![](https://cdn.userecho.com/characters/83.png?1)
Thanks so much. Looks to be working. More 'o' in status window than previous cases. Will update in case there is any issue.
Customer support service by UserEcho
jdbc:sqlserver://192.168.0.5:1433;databaseName=my_database