Conclusion

Here are more resources for migrating to SQL Server 2005:

• How to: Upgrade to SQL Server 2005 with the Copy Database Wizard
• Using the Copy Database Wizard
• Weighing your SQL Server 2005 migration options (Expert Webcast)
• Step-by-Step Guide: Planning your migration to SQL Server 2005

Migrating to SQL Server 2005 is a straightforward process with the Copy Database Wizard, and it will be a common selection for most DBAs when migrating a database and its dependent objects. This point-and-click interface is beneficial to successfully complete the migration process without having to code or script out particular objects. If you have a more complex environment and require more flexibility, review the other options from the tip and webcast in the additional resources list above. Good luck!

Upgrading to SQL Server 2005 using Copy Database Wizard

 Home: Introduction
 Step 1: Plan your migration
 Step 2: Choose your hardware and software
 Step 3: Test your migration process
 Step 4: Be sure you have a corruption-free environment
 Step 5: Migrate using the Copy Database Wizard
 Step 6: Perform post-upgrade tasks
 Step 7: Conclusion

ABOUT THE AUTHOR:

Jeremy Kadlec Jeremy Kadlec is the principal database engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server users groups and nationally at SQL PASS. Kadlec is the SearchSQLServer.com Performance Tuning expert. Ask him a question here. Copyright 2006 TechTarget

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Strategy and planning Tuning SQL Server performance via disk arrays and disk partitioning Virtual database storage for SQL Server: Friend or foe? SQL Server high availability when upgrading to SQL Server 2005 Secure SQL Server from SQL injection attacks How insiders hack SQL databases with free tools and a little luck Storage area network (SAN) basics every SQL Server DBA must know Tips for moving from SQL Server local disk storage to SANs Sarbanes-Oxley compliance checklist: IT security and SQL audits SQL Server PerfMon counters for access methods and buffer manager Find size of SQL Server tables and other objects with stored procedure SQL Server installation How to create a SQL Server linked server to DB2 Tuning SQL Server performance via disk arrays and disk partitioning Virtual database storage for SQL Server: Friend or foe? Tutorial: Migrating to SANs from local SQL Server disk storage How to restore SQL Server database to transition server during upgrade Storage area network (SAN) basics every SQL Server DBA must know Tips for moving from SQL Server local disk storage to SANs SQL Server 2005 log shipping setup using the wizard SQL Server tools don't appear in menu after SQL Server 2005 install Troubleshoot SQL Server 2005 SP2 installation error SQL Server installation Research SQL Server database design and modeling Check SQL Server database and log file size with this stored procedure SQL Server tempdb best practices increase performance FAQ: SQL Server databases how-to How to maintain SQL Server indexes for query optimization How to retrieve SQL Server database disk space in use Maintain large SQL Server database and resolve website 'Timeout Error' How to construct and use SQL OUTER JOINs optimally How to use the LEFT vs. RIGHT OUTER JOIN in SQL Using the FULL OUTER JOIN in SQL SQL OUTER JOIN sample statements for queries

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary binary tree  (SearchSQLServer.com) block  (SearchSQLServer.com) data structure  (SearchSQLServer.com) DDBMS  (SearchSQLServer.com) entity-relationship model  (SearchSQLServer.com) initial extent  (SearchSQLServer.com) primary key  (SearchSQLServer.com) segment  (SearchSQLServer.com) tablespace  (SearchSQLServer.com) view  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary