How to backup database from WinXP and restore in Windows 7 64bit.

Hi,

Im running windows XP 32bit professional with sql server 2005 express as a database for my Bentley select server. I'm planning to upgrade my server to windows 7 64bit pro. I need to backup my database from winXP and restore in windows 7 64bit. What is the best way to do it? Thanks,

Jess
JessIT2013Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
yes, the restore is backwards compatible, sql 2005 backups can be restored on sql 2008 instances.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you "simply" backup the databases on the source server, and restore them on the target server. the 32 vs 64 bit does not impact on the backup/restore functionality.

there are other things to check, see here:
http://technet.microsoft.com/en-us/library/ms186390.aspx
0
 
JessIT2013Author Commented:
Thanks but my new server has sql server 2008 r2 express?

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