April 18, 2012 at 9:58 am
Can someone please provide me the script to do reverse engineering. I have an OLD DB. I would like to see how it has been made. I know through tools, it can be possible. But, would like to see if there is any tool which will be more helpful.
April 18, 2012 at 10:27 am
DBA_SQL (4/18/2012)
Can someone please provide me the script to do reverse engineering. I have an OLD DB. I would like to see how it has been made. I know through tools, it can be possible. But, would like to see if there is any tool which will be more helpful.
For a complete re-engineering you can use Visio Pro or a higher edition, or ERwin.
If all you need is to get the script, you can right-click on the database icon and select Tasks > Generate scripts.
April 20, 2012 at 2:44 pm
Right click on DB -- go to tasks -- select "generate scripts", select the database you want,
then select the objects you want (schemas, stored procedure, synonyms, tables, etc...)
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply