Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Are there any known issues in migrating a SQL Express 2008 database to SQL Server 2008 R2 Standard (x64)? Has anybody done it? I have finally convinced my boss that it would be beneficial to migrate our appliance from Windows XP to Windows Server 2008 R2. Since there is only x64 Server R2, I would like to use SQL Server 2008 x64.

Any shared experiences would be helpful.

Thanks!

share|improve this question

1 Answer 1

up vote 2 down vote accepted

There really should be no problem. I've done various upgrades, from SQL2005x32, SQL2008x32, all to SQL2008R2x64, hardly encountering any trouble. Be sure to have a fallback plan, just in case, other than that there should be no more to it than detaching-moving-reattaching (or backup from old server and restore to new) the databases, moving users and Agent jobs and running UPDATE STATS afterwards. Moving users might be the longest part, there are sql scripts on the web that automate the task.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.