January 14, 2010 at 11:53 pm
Hi,
I'm preparing to make a case to upgrade a Server's Databases from SQL Server 2008.
I do not yet have access to the Server so I can't run the upgrade advisor.
I'm quite familiar with the task in DTS that do not convert over and many of the DBA Commands (System Tables, DMV',s DBCC, Shrink, etc) but I'm particulary concerned about the T-SQL Commands that become obsolete and the impact when upgrading from SQL Server 2000 to 2008.
I have performed the upgrade advisor and subsequently upgraded to SQL Server 2008 at a different client site and I had a link to some links to good articles regarding this subject but my I had to reload my OS and lost them.
I tried to goggle but I could not find the articles that I previously had.
I got a late request late yesterday afternoon and I have a number of other issues that I must prepare for but it would be ideal if I had some link to articles so that I can gather additional information when I meet with the client today.
I found these links and a few others but not a complete list of what I was looking for:
http://www.mssqltips.com/tip.asp?tip=1857
http://technet.microsoft.com/en-us/library/cc721270.aspx
http://windowsitpro.com/article/articleid/100315/review-sql-server-2008.html
http://searchsystemschannel.techtarget.com/tip/0,289483,sid99_gci1306917,00.html (not subscribed)
Also it would be helpful if I had information that I could justify the benefits to help justify the cost.
Any help would be greatly appreciated.
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2010 at 2:46 pm
Thanks
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2010 at 4:58 pm
Welsh Corgi (1/15/2010)
Thanks but I will research it myself.I appiciate all of the the help that I have received.
Giilda Monster dtands out and Rocks and others stand out as they have become helpfuul.
Regards,
Welsh Corgi,
A little Guy with Short Legs and a larger Trunk
In 2005 and 2008 SQL Server uses the ANSI SQL 1999 JOIN syntax which makes the WHERE clause a filter like the AND operator so if you have many old WHERE clause JOIN then you may need some rewrites. If you have TEXT/NTEXT and IMAGE then you need to change that to Varchar(max) and Varbinary(max) these are not depreciated but are just replaced. These are just a few will add more as needed.
Kind regards,
Gift Peddie
January 15, 2010 at 8:54 pm
tks
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2010 at 9:14 pm
If you decide to move the Database to another Server and decomission the current Database Serve, please consider using an Alias SQL Server Name and/or a DNS Entry to redirect.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2010 at 11:50 pm
Gift Peddie
Thanks
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 16, 2010 at 1:13 am
Get a copy of the database on a server that you do have access to and run upgrade advisor. Fix everything it complains about. Upgrade your test server to SQL 2008 and run end-to-end tests of your application. Fix anything that breaks (stuff will). Only way to be completely sure.
Thing is, the query optimiser has changed and there are (rare) cases where queries that are fast on 2000 are slow on 2008. It's usually fixable. Plus the parser is a lot stricter in SQL 2008, so T-SQL that was technically invalid may have been accepted on SQL 2000, but 2008 it'll throw an error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply