Ask a Question

Question

SQL 2005 32 bit – SQL 2005 64 bit

5 pts.

Tags:

SQL Server 2005

SQL Server migration

Moving from SQL 2005 32 bit - SQL 2005 64 bit. What are the problems which can be faced during this move.

Asked: December 1, 2008 9:16 PM Last updated: December 2, 2008 1:50 AM

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Denny Cherry 69,115 pts. · Accepted Answer · 2008-12-02T01:50:13+00:00

Thanks. We'll let you know when a new response is added.

About the only things that you’ll notice are:

DTS doesn’t work anymore
SQL Mail doesn’t work anymore
SSIS Packages and Linked Servers will need x64 drivers installed instead of x32 drivers.

Everything else will be fine. You can easily move a database from x32 to x64 with ease.