October 21, 2013 at 1:42 pm
Can I get some recommendations on some Database Reverse Engineering Tools?
Thanks in advance!
October 21, 2013 at 1:48 pm
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get a database model or something from an existing database?
Two tools come to mind for this type of thing. The first one is the built in database diagrams, the second is Visio.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 21, 2013 at 1:54 pm
Sean Lange (10/21/2013)
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get a database model or something from an existing database?
Two tools come to mind for this type of thing. The first one is the built in database diagrams, the second is Visio.
Didn't they remove the reverse engineering in a recent version of Visio?
I've used ERwin to reverse engineer a database model, but it was not perfect. It was 4 years ago though, a lot might have changed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2013 at 2:03 pm
Didn't they remove the reverse engineering in a recent version of Visio?
Yes, I believe it was removed in Visio 2013.
October 21, 2013 at 2:04 pm
Koen Verbeeck (10/21/2013)
Sean Lange (10/21/2013)
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get a database model or something from an existing database?
Two tools come to mind for this type of thing. The first one is the built in database diagrams, the second is Visio.
Didn't they remove the reverse engineering in a recent version of Visio?
I've used ERwin to reverse engineer a database model, but it was not perfect. It was 4 years ago though, a lot might have changed.
I have Visio 2010 and it is still there...although way difficult to find thanks to the #*$&% ribbon bar. You have to create a new database model diagram (why is a complete mystery to anyone) and then you will get the Database tab. On that tab is the otherwise completely hidden Reverse Engineer button. Pretty sure the same nonsense will exist for 2013 but I don't have that version to check it out.
I have never used ERwin but have heard of other having mixed results with it as well.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 22, 2013 at 6:11 am
Yes, I'm trying to reverse engineer existing sql server databases.
October 22, 2013 at 6:23 am
Embarcadero ER Studio might be worth a look...
October 22, 2013 at 8:58 pm
I use Enterprise Architect (by Sparx Systems) to do this - it will connect to your database and allow you to load (into Enterprise Architect) the definitions of tables, views, sprocs etc. As an added bonus, it also looks at the definitions of views and sprocs and adds extra relationships to the objects used within the view/sproc - it doesn't use the dependency information stored by SQL Server (which may be incomplete anyway because of deferred name resolution).
October 22, 2013 at 9:40 pm
I've used ERStudio and liked it. CA ErWin works, but the last version I used (2002-3) was cumbersome. Visio can do some, but cumbersome as well.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply