Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit

5 pts.
Tags:
SQL Server 2005
SQL Server 2005 (32-bit)
SQL Server 2005 (64-bit)
SQL Server 2005 32-bit to 64-bit upgrade
SQL Server 2005 upgrades
SQL Server upgrades
Hi,

We have one development server which is running on sql 2005 32 bit contains

Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc)

Note: now this databases & application is under development stage.

But our plan is in future we need install SQL 2005 64 bit on QA & PRD server.

My questions are

    1) Is there any problem for database side like( SPs, Queries) will existing things work on 64 bit?
    2) Existing web application will work on sql 2005 64 bit?
    3) Is it possible to restore the 64 bit database backup on 32 bit database?
    4) Is there any things if you have?

Answer Wiki

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

1. No, all your T/SQL will work just the same.
2. It’ll work just fine.
3. Yes you can restore a database between x64 and x32.

As long as you aren’t using SQL Mail, or DTS then you should be fine. If you are using SSIS then you’ll need to be careful with your SSIS packages, and there is some difference in how SQL setups up it’s procedure cache between x32 and x64.

Discuss This Question:  

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following