problems involved in migration of databases from 2005 to 2008

• thudi.rama

  SSC Rookie

  Points: 46

  More actions

  November 19, 2009 at 2:09 pm

  #385820

  I need how to do Migration of databases from sql server 2005 to 2008,What kind of problems involved in this process.

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  November 23, 2009 at 10:18 pm

  #1083263

  The potential problems are the same as any upgrade. Download a copy of the Upgrade Advisor and use it to help plan:

  Upgrade Advisor

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

• support.sql

  Default port

  Points: 1444

  More actions

  November 27, 2009 at 3:14 pm

  #1085051

  Please take as reference this Microsoft Guide

  SQL Server 2008 Upgrade Technical Reference Guide

  http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

  SNM

  Try Free Microsoft SQL Server Data Collector & Performance Monitor.

  http://www.analyticsperformance.com[/url]
  
  @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector