how to identify sql server deprecated features of 2000 and 2005 in 2008 server


Pleanning for a enterpirse server upgrade from 2000 and 2005 servers to 2008, is there any TOOL which would run across the server to identify if there any deprecated commands used in these servers.

I have used SQL server upgrade advisor but its of not much detailed report.

Please let me know if any other tools or any other process involved in usage.

Thanks and regards,

more ▼

asked Jan 07, 2012 at 04:06 AM in Default

avatar image

174 26 27 30

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I wrote a tip on mssqltips.com last year that should help you derive a trace to capture these events and identify where they're coming from.


more ▼

answered Jan 07, 2012 at 12:10 PM

avatar image

905 3 6

(comments are locked)
10|1200 characters needed characters left

You could use Extended Events to identify deprecated features too - a good example here : http://www.mssqltips.com/sqlservertip/1857/identify-deprecated-sql-server-code-with-extended-events/

more ▼

answered Jan 09, 2012 at 02:06 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left

What you could do is take a copy of your database into SQL Server 2008 R2, and capture a day's activity in the form of a trace file that you then replay against the SQL Server 2008 R2 instance. Then you can look at the contents of the system DMV sys.dm_os_performance_counters - look for deprecated feature usage in there. You'll see counts of what features have been used.

See, among others, <http://technet.microsoft.com/en-us/library/bb510662.aspx>, <http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/find-out-if-you-are-using-deprecated-fea-2008>, http://sqlblog.com/blogs/allen_white/archive/2009/05/26/tracking-deprecated-features.aspx

more ▼

answered Jan 07, 2012 at 09:21 AM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 07, 2012 at 04:06 AM

Seen: 3602 times

Last Updated: Jan 07, 2012 at 04:07 AM

Copyright 2018 Redgate Software. Privacy Policy