Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links

News

This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog
 




Archives

Post Categories

About me

SQL Server Upgrade Technical Reference Guide

So, you are considering upgrading to SQL Server 200x from a previous version. What are some of the key issues that you need to consider, or at least be made aware of, prior to upgrading?

Fortunately the heavy lifting of answering that question has already been done for you. It's available to you in the form of an Upgrade Technical Reference Guide. There's one available for upgrading to SQL Server 2008 and one for SQL Server 2005.


Of course, you'll still need to consider the information provided in these documents in light of your specific databases and servers, but at least these will provide a good jump start on the process.

Cheers!

Joe
kick it on DotNetKicks.com

Print | posted on Monday, March 02, 2009 12:28 PM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Thanks Joe, these are good documents for dba library.
Just to let people know. These docs are not just marketing brochures about new features in new version etc. These are comprehensive guides each 500 pages describing all the methods and details of migration.
3/3/2009 4:58 AM | Freelance DBA
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

You're absolutely right. And thanks for mentioning that here.

As an aside, I actually wrote a very small chapter in each of these documents, the upgrading Notification Services chapter.

Cheers!

Joe
3/3/2009 8:28 AM | Joe Webb
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

he SQL Server 2005 database engine implements a highly scalable and available service for data storage, processing, and security to meet the requirements of the most demanding data systems.SQL Server Reporting Services is a new server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources.
2/19/2010 3:49 AM | Casino Amerika Führer
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

SQL Server is important
9/12/2010 2:03 PM | canada goose down jackets
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Of course, you'll still need to consider the information provided in these documents in light of your specific databases and servers, but at least these will provide a good jump start on the process.
10/16/2010 4:00 PM | columbia jackets
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Of course, you'll still need to consider the information provided in these documents in light of your specific databases and servers, but at least these will provide a good jump start on the process.

snow boots | snow boots for women | columbia sportswear | columbia sportswear outlet | cheap north face jackets | the north face outlet | mac makeup | cheap makeup
10/19/2010 4:33 AM | furry boots
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

This super video converter for mac is developed by Emicsoft Studio, it is currently the best video converter running under Mac os x, comparied by isqunite, Visualhub and other Video Converter for Mac Free video converter for Mac, This video converter for Mac is more stable in converting video files and support more
10/26/2010 1:27 AM | hanly
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

This should be (in my opinion) the defacto standard of how pm software should behave - tons of features with svn, bazzar, cvs and git integration, mailhandler like create a ticker by mail, wiki per project and automatic gannt creation.
The only downfall of this amazing piece of software is that it's written in ruby and thus less intuitive to install.
Another contender in the field will probably be openatrium, I predict that a code repository plugin (browser, diffs etc..) will appear between 6-12 monthes.
10/26/2010 12:18 PM | football kits
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Great article, Matt. It's really nice to get to peek at your best practices all in one place. Looking forward to Part 2. Quilted's is now officially on the Drush bandwagon and loving it.
10/26/2010 12:19 PM | Dental Clinic Dallas
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Great article, can't wait for part 2. If you only use Drush for module downloads and updates it is worth investing the time in learning the CLI, huge time saver.
10/26/2010 12:20 PM | San Diego Locksmith
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

You should invest some of your time in order to be better acquainted with the Command Line Interface (CLI). I installed VMWare Player (Free) and downloaded a linux appliance (I choose Cent OS) so I can have on my windows computer a running linux where I do all my CLI stuff, even offline.
10/26/2010 12:21 PM | San Diego Electrical
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Your work is good. This blog is given informative information. Thank you for this useful information. I will share it with my friends. I have done bookmarked it.skireisen
skifahren Ă–sterreich|skiurlaub

11/2/2010 6:35 AM | winterurlaub
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

A recumbent bicycle is a bicycle that places the rider in a laid-back reclining position. Most recumbent riders choose this type of design for ergonomic Recumbent Bicycles and Accessories Built For Performance, Quality, and Comfort by Bacchetta Bikes. recumbent bike For a lifetime of wear, look for platinum jewelry stamped with a fineness mark of 950 Plat or Plat. This indicates a level of purity that will not tarnish Platinum Necklaces for everyday discount prices on Overstock.com! $2.95 shipping and product reviews on products. platinum necklace A gas compressor is a mechanical device that increases the pressure of a gas by reducing its volume. Compressors are similar to The GCA [Gas Compressor Association] is a professional trade organization dedicated to the enrichment of its members and their industry - products and gas compressor Certain comedy varieties of tennis rackets have been produced, characterised by the . A table tennis racket is used by players in the game table tennis. We carry Babolat tennis racquets such as Babolat Pure Drive and Babolat AeroPro Drive used by Andy Roddick and Rafael Nadal. Babolat Tennis also has tennis racket Tungsten Earrings for everyday discount prices on Overstock.com! Get $2.95 shipping on your entire order and read product reviews.Tungsten Earrings from wholesale jewelry distributor and manufacturer, 316Steel. com.Shop for high quality wholesale tungsten carbide in men's earrings products on DHgate and get worldwide delivery. Buy China wholesale tungsten carbide in tungsten earrings
12/24/2010 11:20 PM | nrerr
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

these are good documents for library.Just to let people know. These docs are not just marketing brochures about new features in new version etc. thanks for sharing news.
5/26/2011 4:32 AM | Bengal cat
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Hi, I have been searching everywhere for a tutorial on making fabric covered rings. This is the closest thing Ive found. Any suggestions on turning it into a ring? Also, where did you get your kit? Thank you!
7/27/2011 1:46 AM | jgalejg
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

This article is very good,I like it very much,and welcome to <a title="cheap Tennis Rackets" http://www.cheapwilsontennisrackets.com/"> cheap Tennis Rackets sports series.It can offer you leisure and fashion.
9/6/2011 4:57 AM | cheap Tennis Rackets
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

The info is quite outdated by now. Was searching for some html answers and somehow ended up here.
10/30/2011 4:02 PM | Vero Beach hotels
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

I wanna make an upgrade but I am not familiar enough, only my cousin who had idea about it, but he wasn't here. Can you share the exact guide for this configuration.
10/31/2011 7:55 AM | female entrepreneur coaching
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

I admire the grade of information presented as part of your post. I most certainly will bookmark it and check up here often. We're fairly certain I most certainly will be shown a many new stuff with future!
2/13/2012 12:31 AM | serviced apartments singapore
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Wonderful post, thanks for putting this together! "This is obviously one great post. Thanks for the valuable information and insights you have so provided here. Keep it up.
3/13/2012 2:15 AM | vps
Gravatar

# re: SQL Server Upgrade Technical Reference Guide

Bundle of thanks from my side to you personally for giving us this so much interesting and outstanding platform…after passing in the above part of the page i can't say suitable words for many thanks this brilliant effort.Just want to say please keep posting.
4/9/2012 2:53 AM | xavierdoherty
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET