Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

Microsoft SQL -- 32bit to 64bit ?

What is the easiest way to convert
several old SQL 2000 32bit databases
to SQL 2012 64bit databases ?

Example
  1.      Purchase 64bit server
  2.      Install 64bit Windows 2012 Standard
  3.      Setup Hyper-V #1 VM called AppServer
  4.      Install 64bit application software
  5.      Setup Hyper-V #2 VM called SQLServer
  6.      Install 64bit SQL 2012 Standard
  7.   Detach from 32bit SQL 2000, attached to 64bit SQL 2012” like the below links talk about  ?

  ** http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0d68c0c5-67aa-4860-8e15-e72a2d84f600/converting-database-from-32bit-sql-server-2005-to-64bit-version-of-sql-server-2005?forum=sqlsetupandupgrade

  ** http://stackoverflow.com/questions/2526375/32bit-to-64bit-sql-server-2008-database-conversion
0
finance_teacher
Asked:
finance_teacher
  • 2
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can't migrate from SQL Server 2000 directly to 2012 because isn't supported. You need to migrate first to SQL Server 2005 or 2008 (compatibility only goes 2 versions backwards).

But there's no issues migrating from 32 bit to 64 bit since the databases aren't affected by the architecture. That's more about the efficiency on using the resources.
0
 
finance_teacherAuthor Commented:
So the below will work ?
 1. Detach from 32bit SQL 2000
 2. Attach to 64bit SQL 2005 or 2008 --> like my links talked about
 3. Detach from 64bit SQL 2005 or 2008
 4. Attach to 64bit SQL 2012
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The steps aren't that direct but almost.
Before step 1 and 3 I will recommend you to run the upgrade advisor  (for SQL 2005/8 and 2012 respectively) to check if there are any incompatibilities.
And after step 2 and 4 you will need to set the compatible mode of the database to the version that you migrated to and run the DBCC CHECKDB with the DATA_PURITY option.
DBCC CHECKDB ('<db_name_goes_here>' ) WITH ALL_ERRORMSGS,NO_INFOMSGS, DATA_PURITY

Open in new window

And for last step some people like to also to update the statistics from all tables or even run a full reindex job. This step you can only do it after migrating to SQL Server 2012.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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