Coolthing Of Theday

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 13 June 2013

Dev:"But it's new and shinny! Let's upgrade!" DBA:"Over my..." - Preparing to upgrade your SQL Server

Posted on 18:38 by Unknown

simple talk - Database Administration - Preparing to Upgrade your SQL Server

It isn't a problem to use deprecated TSQL features until it comes to the time  to move the database to a server with a newer version of SQL Server, because The Upgrade Adviser tool will tell you what needs to be changed. An alternative is to flush out the use of archaic features via scripting  during the development process so there are no surprises later. Jonathan Allen shows how.

The job of preparing to upgrade SQL Server is one that DBAs look forward to but also dread in equal measure; on the one hand there is the delighted anticipation of new shiny things to work with, on the other hand the dread of knowing what to do if everything breaks or making sure that everything is ready for the changes? The problem is that your databases may be using features that don’t work in the version of SQL Server you’re upgrading to. If so, then they’ve got to be altered to get everything to work. Only if you make sure that all the databases will work on the new version of SQL Server can you look forward to a stress-free upgrade.

SQL Server makes things as easy as possible for you with various tools and features that let you know what if anything will cause problems and therefore stop working if you upgrade, and they will also warn you what features are likely to be problems in a version or two. There is the upgrade advisor tool, a dedicated application that will analyse all the components of SQL Server that you have installed and produce reports for you to review to guide you through an upgrade. This isn’t what we are going to look at, but I wholly recommend that you take a look at the Upgrade Advisor for the SQL Server version you intend to install, even if you are not intending to upgrade yet, and review what might be a problem and what information you will get out of it. Just so that you are one step ahead when the upgrade *does* get started. The SQL Server Upgrade Advisor can be found here:

...

imageimageimage

Speaking of upgrading SQL Server servers, this looks like some great into for those looking to upgrade now or in the near future.

 

Related Past Post XRef:
"Microsoft SQL Server 2014 CTP1 Product Guide" - One new SQL Server, 12 PDF's...

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in DBA, SQLServer | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Mr. 7,000! This is my 7,000th post...
    Before this post; After; 20 visits between taking these snaps? Oh wait, that's probably me searching for past related posts....
  • "Windows Server Essentials Media Pack" (DNLA Stream, HTML5 and Dashboard Media stuff)
    Microsoft Downloads - Windows Server Essentials Media Pack This pack enables the media streaming functionality for Windows Server 2012...
  • Rad Gate Post... Get your Red Gate Post here...
    simple talk - Melanie Townsend - Get a copy of the Red Gate Post We recently put together a newspaper of some of the best articles fr...
  • Windows Management Framework 4.0 (PowerShell 4, PowerShell ISE, Management OData, WMI, etc.) now available
    Keith Hill's Blog - PowerShell 4.0 Now Available You can get PowerShell 4.0 for down level operating systems now via the WMF 4.0 d...
  • Viasfora - Your new favorite Visual Studio Text/*ML Editing Extension?
    Winterdom - Introducing Viasfora A couple of days ago, I unveiled Viasfora , my latest attempt at building a decently packaged extensi...
  • "Windows Server [2012 R2]: The Best Infrastructure to Run Linux Workloads"
    In the Cloud - What’s New in 2012 R2: Enabling Open Source Software Part 4 of a 9-part series . ... There are a lot of great s...
  • [Hardware Review] Life with Haswell... Haswell/Harris Beach Intel SDS Ultrabook Review - Part 2
    "So Greg, how's life with Haswell been?" "Pretty Sweet! (Mostly)" I've been given an opportunity to review t...
  • Fuzzy Lookup Add-In for Excel (Insert lame "Fuzzy, wuzzy was an Excel..." snip here)
    Microsoft Downloads - Fuzzy Lookup Add-In for Excel The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Exce...
  • Caliburn.Micro v1.5.0 released (CM gets Tasks, Async/Await and Share/Setting for RT... and bug fixes of course)
    Caliburn.Micro - Caliburn.Micro v1.5.0 "Release Notes This release fixes many bugs. It also adds support for Task and async/a...
  • Just about everything you ever wanted to know about SQL Server Date and Time Data Types...
    CodeProject - Date and Time Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012) Introduction It would be bette...

Categories

  • .Net
  • 3DPrinting
  • AFeedYouShouldRead
  • Agile
  • ALM
  • Amazon
  • Amiga
  • Analytics
  • Android
  • ASP.NET
  • Azure
  • BigData
  • bing
  • Blogging
  • Book
  • BookReview
  • BUILD
  • C
  • C#
  • C++
  • Career
  • Cat
  • cheatsheet
  • ClickOnce
  • Cloud
  • ComputerHardware
  • css
  • Data
  • DBA
  • DependencyInjection
  • Deployment
  • Design
  • Development
  • devops
  • DVCS
  • ebook
  • EDD
  • Education
  • EnterpriseLibrary
  • EntityFramework
  • Exchange
  • Expression
  • gadget
  • Game
  • GIT
  • Google
  • Government
  • Hadoop
  • hardware
  • HardwareReview
  • HaswellReview
  • HTML5
  • Humor
  • IE
  • IEExtension
  • IfAllElseFails
  • IIS
  • ILMerge
  • Image
  • Infographic
  • interview
  • InversionOfControl
  • Java
  • Javascript
  • Kinect
  • LightSwitch
  • LINQ
  • Linux
  • LosAngeles
  • Lucene
  • Lync
  • MEF
  • Metro
  • MicrosoftOffice
  • MicrosoftOutlook
  • Mono
  • MVC
  • MVVM
  • NetMon
  • NLP
  • NoSQL
  • NuGet
  • OData
  • OneNote
  • OpenXML
  • Paint.Net
  • Personal
  • Photosynth
  • Physics
  • portable
  • Poster
  • PowerShell
  • Preparedness
  • Presentation
  • Prism
  • PrivateCloud
  • RegEx
  • RemoteDesktop
  • Reporting
  • RIAServices
  • Science
  • ScienceFiction
  • Scratch
  • Scrum
  • ServiceBus
  • SharePoint
  • Silverlight
  • SimiValley
  • SPA
  • Space
  • SQLServer
  • Storyboard
  • Surface
  • SVG
  • SystemAdministration
  • T4
  • TeamBuild
  • TeamFoundationServer
  • TechEd
  • Training
  • TypeScript
  • UnitTesting
  • UnityApplicationBlock
  • Utility
  • Veteran
  • VirtualMachine
  • Visio
  • VisualBasic
  • VisualStudio
  • WCF
  • Web X.X
  • Webcast
  • WebFeed
  • WebMatrix
  • Windows
  • Windows7
  • Windows8
  • Windows8.1
  • WindowsHomeServer
  • WindowsLiveWriter
  • WindowsPhone
  • WindowsServer
  • WinRT
  • WiX
  • WMI
  • WOPI
  • WPF
  • XAML
  • XBox360
  • XboxOne
  • zombie

Blog Archive

  • ▼  2013 (500)
    • ►  December (12)
    • ►  November (61)
    • ►  October (65)
    • ►  September (38)
    • ►  August (47)
    • ►  July (75)
    • ▼  June (39)
      • 300 for 320 - 320 Windows 8.1. app and code sample...
      • "Utilizing SysInternals Tools for Windows Client" ...
      • Google .Net API's go portable... The v1.4.0 Google...
      • Goodbye Google Reader... Need an alternate app? He...
      • Scott (not that Scott) helps make your Live dev ea...
      • SSDT (SQL Server Data Tools) June 2013 Released
      • RSAT (Remote Server Administration Tools) for Wind...
      • Getting a picture of the "Blue" Wave...
      • Need some help up the WPF learning curve? "WPF Suc...
      • A Sweet Summer Sysinternals Suite Refresh
      • Robin's "So you're in San Francisco for Build? Stu...
      • TypeScript Succinctly - Free [Name/email-ware] eBook
      • Friday Humor: Cell Reception - Can you hear me...o...
      • Mark TechEd's you... See all four of Mark Russinov...
      • Fighting bugs in your LOB apps? Hearing about cras...
      • Greg's //build bets - My total and complete WAG's ...
      • Excel as a digital art drawing platform? Yep! Beau...
      • Want the world's best Science Fiction And Fantasy ...
      • Eric triple downs on his Free Microsoft eBook List...
      • Log Parser Studio 2.0 now out (Log Parser GUI++)
      • //build Windows Store App available
      • Booting Minecraft (or maybe Assembling Minecraft) ...
      • POP goes the code review... Prince Of Persia Apple...
      • So you want to be a dev at Microsoft? Here's two v...
      • "The Essential HTML5 Mobile" DZone Refcardz Cheat ...
      • WPF TextBlock vs Label, what's the diff?
      • A quick look at the coming Los Angeles Light Rail ...
      • Dev:"But it's new and shinny! Let's upgrade!" DBA:...
      • "Microsoft SQL Server 2014 CTP1 Product Guide" - O...
      • Win8Templates now at 71 - 71 Windows 8 App Design ...
      • Getting into the flow, surfing restaurant inspecti...
      • Mash some web API's with your brain and Windows 8 ...
      • Using .Net Settings? Hate it when you rev your app...
      • Tiny Tiny RSS WAMP, MAMP or LAMP installers, VM or...
      • WintellectNOW FTW - Wintellect now providing on-de...
      • Windows 8 Mail Tip - Pin Email accounts so you see...
      • Gov Webicons - Your one shop, 41 Agency stop for U...
      • With yesterday's TechEd VS/TFS announcements, does...
      • TechEd NA 2013 Day 1 Announcement Round-up - VS 20...
    • ►  May (40)
    • ►  April (42)
    • ►  March (39)
    • ►  February (42)
Powered by Blogger.

About Me

Unknown
View my complete profile