• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

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?
0
GordonLiq
Asked:
GordonLiq
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
GordonLiqAuthor Commented:
Thank you , soulds like I can upgrade to 2008 64 system and database without any problem.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now