• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

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.
3 Solutions
here would be an excellent start for you
this article will give you a good step by step guide
Detaching and reattaching databases link  helped me when I needed.

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.
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now