tool that can give the list of depricated features in sql 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » tool that can give the list of depricated...

tool that can give the list of depricated features in sql 2000

Rate Topic

Display Mode

Topic Options

Author

Message

mpalaparthi

Posted Monday, October 29, 2012 7:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:40 PM
Points: 35, Visits: 424

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

bitbucket-25253

Posted Monday, October 29, 2012 7:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 5,102, Visits: 20,205

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

mpalaparthi

Posted Monday, October 29, 2012 8:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:40 PM
Points: 35, Visits: 424

Thanks for the reply....

Post #1378287

bitbucket-25253

Posted Monday, October 29, 2012 12:00 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 5,102, Visits: 20,205

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

mpalaparthi

Posted Monday, October 29, 2012 12:42 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 1:40 PM
Points: 35, Visits: 424

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 »

Permissions