[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Sql Server 2008 64bit and 32bit software

Posted on 2009-07-11
3
Medium Priority
?
428 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 2000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
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…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

591 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