SSWUG TV
With Stephen Wynkoop
Today on SSWUG TV find out some of the latest news from the Sharepoint 2011 and the Oracle OpenWorld 2011 Conferences.
Watch the Show
SQL Server Migration
Today we have some questions and comments regarding SQL Server Upgrades.
Stephen:
What Version of SQL Server are you talking about?
Stacy:
During our last migration to SQL 2008 from 2000 and 2005, we just restored the database from the old server to the new server.
At the time we also upgraded the operating system to Windows Server 2008.
Except for growing pains due to the use of Vmware and not physical machines, we had no problems doing it this way.
I expect that is what we will do when migrating to the new version.
Martin:
I am much interested in how to host MSSQL in the cloud as a service.
The current version of SQL Server code named Denali is currently in the Community Technical Preview (CTP) stage. The CTP was released in conjunction with last year PASS summit. It has been in CTP status for almost one year. Some have guessed that Microsoft may announce the release date of Denali at this years PASS Summit which is October 11-14. But that is only conjecture.
It is probably reasonable to guess that Denali will ship within 12 months; I wouldn’t be surprised if the ship date was much sooner. Either way, if you have reviewed the CTP and found compelling features your company needs, or if you are going to be building out new systems, its often effective to have a single version to support…something for the next newsletter.
There are a number of ways to upgrade from one version to the next. With SQL Server 2005 and 2008 you could simply mount the previous versions of the database using the new engine and it would automatically update the database, as Stacy describes.
This technique doesn’t always work with other features of SQL Server such as Reporting Services, Integration Services, or Analysis Services. In comparison, Analysis Services is going to have a lot more new features in the Denali release than the Data Engine.
As Martin suggests, it may be time to look into SQL Azure, or Cloud hosting of your SQL Server databases. At that point you may not be responsible for the upgrade of the software. But there will be some learning there for those transitioning to the Cloud, or upgrading their current hosting.
Do you have upgrade concerns or questions? Drop me a note at btaylor@sswug.org. Your input can be useful for future SSWUG assistance in SSWUG TV, editorials, articles, facebook postings, or even online training.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
Ten Breakthroughs That Changed DB2 Forever (Part 2)
Today, DB2 is a high-speed, enterprise DBMS with unparalleled transaction processing capabilities. But it wasn’t always that way. These innovations helped push DB2 to the top.
Featured White Paper(s)
Structuring the Unstructured: How to Dimensionalize Semi-Structured Business Data
Written by Interactive Edge
The Business Intelligence industry … (read more)