March 15, 2007 at 4:05 am
Hi,
I am looking for a tool or package that will help me 'document' my database. The background behind this is that there is a lot of development in our databases at the moment and it is often the case where different dbas/developers are not aware what others are doing. What I need is something that will allow me to identify where else a SQL object ( a table or column or sp ....) is being referenced in the database? If I change an object I dont want to fix one problem and create two more.
Anybody know if such a tool exists???
Many Thanks!!!!
March 15, 2007 at 4:18 am
Hi Garry,
Red Gate has several tools which will help you with this - SQL Doc will generate documentation for you database including dependency information. SQL Dependency Tracker has the ability to generate graphs of dependencies which you can then print off or save to visualise your database wide dependency information. Finally SQL Compare and SQL Data Compare might well be worth looking at to help generate change scripts for moving objects from dev to test to production. A 14 day free trial of all of the above tools are available from our website.
Hope this helps,
- James
--
James Moore
Red Gate Software Ltd
March 15, 2007 at 4:31 am
Thanks for this James... I will take a look....
March 16, 2007 at 1:45 am
Hi,
Apex SQL also has a great tool. Called ApexSQL Doc. http://www.apexsql.com/sql_tools_doc.asp
Regards,
M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply