Search
Free Signup | Login
Home

Products
       Storefront
          Features
          Documentation

Articles
       .NET
       ASP.NET
       Business Tech
       Common Sense
       DotNetNuke
       Flash
       Javascript
       Linux
       Perl
       PHP
       PowerShell
       Security
       SEO
       SQL
          Firebird
          MySQL
          Oracle
          PostgreSQL
          SQL Server
          Object Databases
       Web 2.0
       Windows
       XML

Free Tools
       ASCII Table Characters
       Fly2 - Shorten Long URL
       HTML Entities Table
       Map Finder
       Ping
       Retirement Calculator
       Roulette
       Unit Converter

Support
       Forum

About Us
Visit: Articles September 3, 2010
Search Articles
Topics
Article List
Article Archive
Relevant Links
Easy Upgrade SQL Server 2000/2005 to SQL Server 2008
Location: BlogsRevindexSQL    
Posted by: revindex 10/31/2008 8:26 AM

SQL Server 2008 is 100% backward compatible with SQL Server 2005. Simply take a full backup in SQL Server 2000\2005. Copy the backup files to the new server and restore from the backup. Change the compatibility level to 100.0 and run sp_updatestats. Everything should run as normal.
Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 
Home|Products|Articles|Free Tools|Support|About Us
Copyright Revindex. All Rights Reserved. Terms Of Use Privacy Statement