0
Under review

how to use the reverse Reverse engineering to? 14?

mo aarab 3 years ago • updated by Rafał Strzaliński (Senior Engineer) 3 months ago 4

is it possible to get an example to SQL Server 14? I'm don't know anything of java

Answer

Answer
Under review

Please:
1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar
2. Download jdbc driver https://www.microsoft.com/en-us/download/details.aspx?id=11774 (exe file should install jar somewhere)
3. In the download folder do:


java -cp .:reverse-engineering-1_6_12.jar:sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] -user USERNAME -password PASSWORD -o OUTPUT_FILENAME


I hope this helps.


Best regards,

Adam Mościcki

Answer
Under review

Please:
1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar
2. Download jdbc driver https://www.microsoft.com/en-us/download/details.aspx?id=11774 (exe file should install jar somewhere)
3. In the download folder do:


java -cp .:reverse-engineering-1_6_12.jar:sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] -user USERNAME -password PASSWORD -o OUTPUT_FILENAME


I hope this helps.


Best regards,

Adam Mościcki

I tried your suggestion but I get the same error:

java -cp .;reverse-engineering-1_6_12.jar;sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver:// SQL\Instance:1433;DatabaseName=Name  -o wp.xml
Error: Could not find or load main class com.vertabelo.reverse.Main

What is the privilege required for the "user" account to reverse engineer an oracle database . Just read access to the tables or schema ?  is there any higher privilege needs to be set ?

Reverse engineering requires read access to the metadata tables. Oracle database  has tables called like: all_objects,  all_synonyms  etc.