October 9, 2006 at 11:46 am
Hello,
Our group is thinking about migrating to SQL Server 2005 next year. I wonder if there are third party tools out there that can help me quickly understand the schema and function of several hundred SQL Server 2000 VIEWs that are contained within five different databases. There are some VIEWS that just contain 'SELECT * FROM...' statements. There are some that have more extensive expressions, but do not filter data. Is it possible to have one reference where I can see information like the schema, and dependiencies of these VIEWS? Is it just as easy to script out the VIEWs and crunch through the scripts? Among other things, we need to address VIEWs that are resource intensive, or redundant, or not used very often.
Maybe there is already a very good way to do this in EM. How would you approach this kind of research? What kind of tool(s) would you use?
Thank you for your help!
CSDunn
October 10, 2006 at 1:34 am
Hi there,
You might want to have a look at Red Gate's Dependency Tracker - this allows you to see your objects and thier dependencies. You can download a fully functional free trail from http://www.red-gate.com/products/SQL_dependency_tracker/index.htm
Hope this Helps,
- James
--
James Moore
Red Gate Software Ltd
October 11, 2006 at 8:15 am
Thank you for your help!
CSDunn
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply