You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server
2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also
need to ensure that the new Transact-SQL functionality in SQL Server 2012 can be used in the
database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
Perform a side-by-side installation of a 32-bit SQL Server 2012 instance.
B.
Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
C.
Perform an in-place upgrade to 64-bit SQL Server 2012.
D.
Detach the database from the old instance and attach it to the new instance.
E.
Change the compatibility level of the database.
Explanation:
Use detach and attach operations to upgrade a SQL Server 2005, SQL Server 2008 or SQL Server
2008 R2 database in SQL Server 2012. After being attached to SQL Server 2012, the database is
available immediately and is automatically upgraded.
Not sure if the answers is set wrong or it’s my PC, but in case everyone has that problem:
The answer is BDE
Yes, it is BDE
B – Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
D – Detach the database from the old instance and attach it to the new instance.
E – Change the compatibility level of the database.