MSSQL 3rd Part Admin tools - Capture Query, list all indexes, FKeys, etc.

We use an ERP Program that is going to a major upgrade and part of that is having to find custom triggers, indexes, FKeys, etc and knowing what is there and what we might need to remove and re-add, etc.

Also the reporting uses QRP and unlike SSRS or Crystal there's no way to see what the query consist of and we would like to capture that query.

We have used SQL Profiler, which I am not very good at.. so we were wondering if there was any 3rd part programs that might do it all or most etc.

Thanks.
LVL 24
DMTechGrooupAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Assuming the SQL Code is not encrypted in the database the easiest I know of to capture any "delta's" (changes) done by/after an upgrade is to have your SQL Database scripted ALL (and I mean ALL objects in it - Tables,Views,Triggers,Indees,PK,FKEy,ECT...by using SQL own SSMS for instance) then make sure you SAVE that script somewhere.

Now you go through the upgrade process and changes hapen to your database (still - SQL profiler would capture ALL these changes as they are done if you just filter it per database) then you can Scripts again ALL objects in that Database(S) and use something like Notepad++ or any other free tool to show the DIFF's between the two files - prior aand post upgrade.


Another very easy and reliable way to find ALL schema changes done to a SQL Database is to use SQL own "Schema Change History" in SSMS - just right click on a database in SQL SSMS then select Reports, then Standard, then Schema Change History - it will show any changes done to a database between SQL Server Service restart.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DMTechGrooupAuthor Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.