We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.
My question are:
Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?
If ok, how to do that?
Any info will be highly appreciated! Thanks!
Best Regards,
Kevin
Hi Kevin.
The on-disk layout of database files is the same for 64bit and 32bit databases, there's no difference...you can freely attach/detach, backup/restore, etc. to/from 32bit/64bit systems and vice-versa at will with no issues. Of course, this assumes you are moving the between supported migration/compatibility instances...i.e. you couldn't move a Sql 2005 64bit database to a Sql 2000 32bit system...
HTH
|||Hi, Chad:
Greate thanks for your reply!
Best Regards,
Kevin
No comments:
Post a Comment