Sql Server 2008 64bit and 32bit software

Hi ,

I am currently running a windows 2003 and asp.net 3.5 and sql server 2005 standard. all of them are 32bits.
Now I am planning to upgrade a new server . and willing to go with windows 200864bit and sql server 2008 64bit.
Can I do that ?
the development env will still in Vista 32bits and VS2008 32 bits.

questions:
Can I replication between 2008 64bit and 2008 32bit express to keep a copy of database?
Can I running the 32bits asp.net program with 64bits Sql server?
GordonLiqAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Can I replication between 2008 64bit and 2008 32bit express to keep a copy of database?

No Issues. You can do replication between 2008 versions without considering bit versions

Can I running the 32bits asp.net program with 64bits Sql server?

Yes..ASP Application will connect to SQL Server irrespective of its bit versions.
Bit versions are applicable for SQL Server Installations only. Once it is Installed, then everything becomes a SQL Server 2008 database only.

Hope this helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GordonLiqAuthor Commented:
Thank you , soulds like I can upgrade to 2008 64 system and database without any problem.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes.. You can upgrade to 64 bit version of SQL Server 2008 without any problem.
Request you to use the Upgrade Advisor to upgrade without any issues:

http://www.microsoft.com/downloads/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.