Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit
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?
Pls send me asap.
Thanks in adavance
Jadi
Software/Hardware used:
Software/Hardware used:
ASKED:
November 26, 2008 6:51 AM
UPDATED:
November 28, 2008 7:05 AM
RELATED QUESTIONS
Answer Wiki:
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 <a href="http://itknowledgeexchange.techtarget.com/sql-server/how-sql-decides-how-much-procedure-cache-and-how-much-buffer-cache-to-use/">procedure cache</a> between x32 and x64.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
