donkaiser

Hello,

Is there a way to reverse engineering a relational database from a stored procedure
I can map out the database manually but it would be nice to know if there's any tool (visio ) to do the job and save time.

Thank you


Re: Modeling and Tools Reverse engineering from stored procedures

Adamus Turner

Hi Don,

Of course you can ALTER the database design through many conventions including stored procedures, but it sounds like you're looking for relationship diagrams and such strictly for documentation purposes

Visio should work fine for you.

Adamus






Re: Modeling and Tools Reverse engineering from stored procedures

donkaiser

Oh great. any suggestion on tutorial to accomplish the task




Re: Modeling and Tools Reverse engineering from stored procedures

LivetoCodeCodetoLive!

I hope these links help you.

http://msdn2.microsoft.com/en-us/library/aa140264(office.10).aspx

http://msdn2.microsoft.com/en-us/library/aa662937(office.11).aspx

If you find them useful, please mark this post as useful.