SQL server 2000 to SQL 2008 R2 Migration

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.
rigelnetAsked:
Who is Participating?
 
plusone3055Commented:
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
0
 
5teveoCommented:
Detaching and reattaching databases link  helped me when I needed.

http://support.microsoft.com/kb/224071
0
 
Jim P.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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.