Vertabelo Reverse Engineering Tool doesn't extract databases
Mariusz M fa 8 anys • updated by kate Winfield fa 4 anys • 9
Why Vertabelo Reverse Engineering Tool extracts tables only from master system database in MSSQL Express?
Did you try to set the relevant connection property? I mean you can explicity set the database name to connect to. Just like this:
Customer support service by UserEcho
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?
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.
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
Probably your shell interprets semicolon as a new instruction.
I was able to reproduce similar behavior.
Please, try again with quotation marks.
YES. It works with the quotation marks. Thanks So much....
Thanks so much. Looks to be working. More 'o' in status window than previous cases. Will update in case there is any issue.