Solved

SQL Express 2005 Compatible with SQL Server 2005?

Posted on 2007-04-02
1
220 Views
Last Modified: 2010-03-19
We are on a dedicated server and have a shopping cart (VP-ASP) that runs on a SQL database which is located on a separate shared server.  We want to move to a different dedicated server at a different hosting company, but they do not offer shared SQL servers, and we would instead have to run the SQL database on the same server our website is running.  Since we don't want to pay the extra money per month for SQL Server 2005 Workgroup or Standard Edition, can we simply install SQL Server 2005 Express edition instead (it's free) and have it work just as our SQL database on the shared server is working? - I don't quite understand why one costs thousands of dollars, while the SQL Express version is free, or what the differences between SQL Server 2005 and SQL Server 2005 Express Edition are.  We don't want to develop anything; we simply want to be able to connect to our shopping cart database.
0
Comment
Question by:cleversley
1 Comment
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 18841942
Sql Server 2005 express is a limited version. It dosent support many functionalities but if you have small database then you can simply use it. in your case "simply want to be able to connect to our shopping cart database." i think you can use it provided it is small less than 4 GB of size
check this comparison between editions

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now