Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

tool that can give the list of depricated features in sql 2000 Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 7:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 3:22 PM
Points: 42, Visits: 485
Hi All,

we are in the process of upgrading our SQL servers 2000 (SP1) to sql server 2008 r2 version. I know that we have lot of features changed/depreicated from sql server 2000 to sql server 2008. I was wondering if we have any tool or some other way that scans all our databases and queries and gives us the list of all the features that needs to be modified before we upgraded the servers to 2008 version (For Ex: If we have some thing liek this "*=, =*" ........... that tool should gives this info)

I really appreciate your help.

Thanks
Post #1378244
Posted Monday, October 29, 2012 7:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:53 AM
Points: 5,472, Visits: 23,535
For a free tool (Microsoft's upgrade advisor) go to this link:

http://msdn.microsoft.com/en-us/library/ms144256.aspx


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1378253
Posted Monday, October 29, 2012 8:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 3:22 PM
Points: 42, Visits: 485
Thanks for the reply....
Post #1378287
Posted Monday, October 29, 2012 12:00 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:53 AM
Points: 5,472, Visits: 23,535
I do not have an instance of SQL Server 2000 available for checking, but you might want to test by using this:

select * from master.dbo.sysperfinfo

If you do use the above, please post back on your results, it might assist others with the same situation as yours.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1378395
Posted Monday, October 29, 2012 12:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 3:22 PM
Points: 42, Visits: 485
Hi Ron,

Here is the output of that T-SQL query:

Object_Name Counter_Name Instance_Name cntr_Value cntr_type
SQLServer:Buffer Manager Buffer cache hit ratio 2676 537003008
SQLServer:Buffer Manager Buffer cache hit ratio base 2680 1073939459
SQLServer:Buffer Manager Page lookups/sec -2025620116 272696320

etc.......

I think I was looking for the list of deprecated features that are in my current sql 2000 environment and needs to be modified while going to sql 2008 version

Thanks & Regards
Post #1378412
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse