Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
| Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 1st, 2006, 11:13 PM
Authorized User
 
Join Date: Mar 2005
Location: Bangalore, Karnataka, India.
Posts: 36
Thanks: 2
Thanked 1 Time in 1 Post
Default migrating from sql server 2000 to sql server 2005

What are the issues those will come up while migrating from sql server 2000 to sql server 2005?
  #2 (permalink)  
Old August 4th, 2006, 07:57 AM
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Most obvious is the DTS to SSIS conversion.

  #3 (permalink)  
Old December 1st, 2006, 03:45 PM
Wrox Author
 
Join Date: Dec 2006
Location: kirkland, wa, USA.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It depends on which features you use.

Rather than try and figure this out, run the Upgrade Advisor which does a great job of finding all the issues, and reporting on them.



Co Author "Professional SQL Server 2005 Administration"


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Upgrade to SQL Server 2005 from 2000 srotondo SQL Server 2005 2 February 14th, 2008 02:26 PM
Difference B/W sql server 2000 and 2005 bhasker_braj121 SQL Server 2005 1 January 19th, 2008 12:01 PM
SQL Server 2000 and 2005 ninel SQL Server 2005 4 September 14th, 2006 01:03 PM
Migrating SQL Server 7 to 2000 dg1234 SQL Server 2000 1 January 28th, 2004 02:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.