SQL server 2000 to SQL 2008 R2 Migration

rigelnet
rigelnet used Ask the Experts™
on
we are using SQL 2000 for a custom built in software. Because of some limitation of sql 2000 we want to move with SQL 2008 R2.

Kindly suggest the best practises or step by step guide to move from SQL 2000 to SQL 2008 r2.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
here would be an excellent start for you
this article will give you a good step by step guide
http://sqlmag.com/sql-server-2008/how-upgrade-sql-server-2008-sql-server-2000
Top Expert 2012
Commented:
Detaching and reattaching databases link  helped me when I needed.

http://support.microsoft.com/kb/224071
Most Valuable Expert 2014
Commented:
Are you sure the custom built in software can be moved and will work with SQL 2008?

I would test it thoroughly in a non production environment first. Including EOM and EOY functions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial