Moving SQL Between XP and Windows 7 (64 Bit) 1

[Auguy]

This has probably been answered before but here goes. I have SQL 2000 & 2005 on my current XP box. I am getting a new computer with Windows 7 64 bit. I'm assuming I will have to download and install the 64 bit development versions of both 2000 & 2005. I would like to be able to move my small development databases back and forth between XP and Windows 7. I don't want to move between 2000 and 2005. Most of the time I would be moving from Windows 7 to XP, but there might be times I would go the other way. I'm assuming Detach/Attach won't work. What about Backup/Restore? Can somebody point me in the right direction for the correct way of doing these moves?


Auguy
Sylvania/Toledo Ohio

 

[gmmastros]

You do not need to install the 64-bit version of SQL Server. A 32-bit version can be run on 64-bit hardware.

If you choose to install the 64-bit versions (personally, I would), all you need to do is to make sure the versions are the same (2000, 2005, etc...). You can detach/attach from 64-bit to 32-bit without any problems. The actual file structure is not dependent on the number of bits your processor has.

Backup/Restore is the same way. You can backup and restore regardless of the number of bits.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Auguy]

Thanks George, I was hoping that was the case, but couldn't find any definitive answers. Most of what I found was moving from 2000 to 2005, etc.

Auguy
Sylvania/Toledo Ohio

 

[gmmastros]

You're welcome.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Are you sure there is SQL 2000 64 bit?

In any case, I would install the 64 bit versions, although there may be some pitfalls, see

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wan

PluralSight Learning Library

 

[gmmastros]

I am sure that there is a SQL 2000 64-bit enterprise and developer editions.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[TonHu]

You can access (no pun intended) the database from both workstations at the same time, but one of them needs to access it remotely. They have to be in the same network ofcourse.

Another good option would be to set up a server that runs both instances of SQL Server, and you can access it from anywhere in your network. Just like in a standard deployment situation.
Access speed shouldn't be an issue, unless your network is below 100 MBit/s speed.