Solved

Sql Server 2008 64bit and 32bit software

Posted on 2009-07-11
3
418 Views
Last Modified: 2013-12-01
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
Comment
Question by:GordonLiq
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24830144
>> 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
 

Author Closing Comment

by:GordonLiq
ID: 31602387
Thank you , soulds like I can upgrade to 2008 64 system and database without any problem.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24833430
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question