SQL Server upgrade and migration

MUST READ Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003 TIP - This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability. Working with schemas in SQL Server 2005 TIP - If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL feature: schemas. Find out how schemas can help. Create an upgrade plan for your move to SQL Server 2005 TIP - Before upgrading to SQL Server 2005, make decisions about print statements, testing QA, rolling back and in-place SQL Server upgrade vs. hardware migration. Top 10 new features in SQL Server 2005 TIP - From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond. Upgrading to SQL Server 2005 FAQs FAQ - Here's a list of frequently asked questions that address your SQL Server 2005 upgrade issues, including DTS packages, copying databases and creating passwords.

EXPERT TECHNICAL ADVICE: 1 - 3 of 61

	SQL Server consolidation: Why it's an optimization technique Submitted By: SearchSQLServer.com | 30 Sep 2008 TIP - SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.

	Should you upgrade to SQL Server 2005 or SQL Server 2008? Submitted By: SearchSQLServer.com | 13 Aug 2008 TIP - Is your organization evaluating whether to upgrade. Let this SQL Server expert advice help you weigh your options for upgrading from SQL Server 2000.

	Monitor database mirroring and replication after a SQL Server upgrade Submitted By: SearchSQLServer.com | 05 Aug 2008 TIP - Learn how to monitor your database mirroring and replication setup after upgrading an Active/Active cluster to SQL Server 2005.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER UPGRADE AND MIGRATION

REFERENCE & LEARNING: 1 - 3 of 13

	Tutorial: SQL Server Integration Services (SSIS) best practices SearchSQLServer.com | 17 Nov 2008 TUTORIAL - Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.

	FAQ: SQL Server databases how-to SearchSQLServer.com | 19 Mar 2008 FAQ - Troubleshoot SQL Server database issues with these FAQs. Whether it's how to back up, restore, import, export, copy or upgrade SQL Server databases, you'll get expert advice here.

	Upgrading to SQL Server 2005 FAQs SearchSQLServer.com | 17 Sep 2007 FAQ - Here's a list of frequently asked questions that address your SQL Server 2005 upgrade issues, including DTS packages, copying databases and creating passwords.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER UPGRADE AND MIGRATION

NEWS: 1 - 3 of 16

	New SQL Server BI features could cut IT chores SearchWinIT.com | 06 Oct 2008 ARTICLE - The next release of Microsoft's SQL Server database brings self-service analysis tools and better reporting features straight to end users. But will it be less work for IT?

	Q&A: What's new in SQL Server 2005 SP1 SearchSQLServer.com | 04 May 2006 INTERVIEW - SQL Server 2005 Service Pack 1 provides production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and more.

	SQL Server 2005 SP1 ships SearchWinIT.com | 19 Apr 2006 ARTICLE - SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1.

	VIEW ALL NEWS ON SQL SERVER UPGRADE AND MIGRATION

BEST WEB LINKS: 1 - 2 of 2

	SQL Server World Wide User Group Help Center http://www.sswug.org/ | 22 Jul 2005 BEST WEB LINK - This Web site allows subscribers access to educational webcasts, discussion forums, database news, script manager and e-mail discussion lists

	How to upgrade from SQL Server 6.5 Microsoft | 18 Feb 2005 BEST WEB LINK - Learn how to convert data from Microsoft SQL Server 6.5 to Microsoft SQL Server 2000 using the SQL Server Upgrade Wizard.

	VIEW ALL BEST WEB LINKS ON SQL SERVER UPGRADE AND MIGRATION

	SEE ALSO - Topics Related to SQL Server upgrade and migration:  SQL Server overview, SQL Server 2008 (Katmai), SQL Server 2005 (Yukon)