SQL Server Express >>> SQL Server

Hi SQL Server gurus

I have developed a web-site using SQL Server Express -- mainly due to the open licence.  Now, when I look at the hosting companies, I see that some of them do not support SQL Server Express, allegedly due to performance issues.  Is this a valid argument?  In short, I am trying to find out whether SQL Server Express is good enough for me -- because it definitely seems to do what I want it to do -- OR should I be seriously thinking of upgrading as SQL Server Express will give me problems down the road?  Will it be able to take the load when site traffic picks up?  Is it fairly straightforward to migrate?

 I would be happy to hear from those who have used both versions -- of the pros and cons.

Thanks

Fouwaaz


Somewhere, something incredible is waiting to be known -- Carl Sagan
0
mfouwaaz
2/15/2008 9:39:39 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

5 Replies
546 Views

Similar Articles

[PageSpeed] 14

The main difference between Express and Full is that Express is limited to 4GB in size, the use of one processor and 1GB of RAM.  For a shared hosting environment, this probably will not offer sufficient performance.  The good news is that databases developed on Express will run on full without modification.

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

 


Regards Mike
[MVP - ASP/ASP.NET]
My site
0
Mikesdotnetting
2/15/2008 9:52:41 PM

Thanks Mike.  It looks like I can stick with it for the time being.  When the database begins to grow toward the 4GB mark, I could think of upgrading, I suppose.  Upgrading -- what does that involve?  Simply open the mdf in SQL Server full version and run some kind of built-in routine?  Or does it involve manual manipulation?  Will be other changes that I'd have to make to the site -- other than the web,config connection string?

 Thanks

Fouwaaz


Somewhere, something incredible is waiting to be known -- Carl Sagan
0
mfouwaaz
2/15/2008 10:16:10 PM

Typically, you just need to attach the database to the instance of Sql Server that you want to run it on, add any logins to Sql Server that you need, and change the connection string to point to the new database server.

 


Regards Mike
[MVP - ASP/ASP.NET]
My site
0
Mikesdotnetting
2/15/2008 10:22:31 PM

Hi Mike

 Do you mean that I can do my development in SQL Server Express and then attach that same database file to any SQL Server full version running on a host?  Sorry it sounds like a dumb question but I am a bit confused.

 Thanks & Regards

Fouwaaz


Somewhere, something incredible is waiting to be known -- Carl Sagan
0
mfouwaaz
2/16/2008 1:01:11 AM

Yes, that is exactly what I mean.

 


Regards Mike
[MVP - ASP/ASP.NET]
My site
0
Mikesdotnetting
2/16/2008 8:55:49 AM
Reply:

Similar Artilces:

Sql Server 2000->->->->->Data->->->-> Sql Server 2005
How can i migrate data from Sql Server 2000 to  Sql Server 2000 A backup file of SQL 2000 can be restored on SQL 2005   ThanksMark post(s) as "Answer" that helped youElectronic ScrewWebsite||Blog||Dub@i.net...

Recommendation
Hiya, I'm looking for some quick advice on how to achieve a task I've been trying to do. The situation: I run a script on my various SQL Servers (2000 and 2005). The script's output is an XML file. (I chose XML because the majority of the servers are on their own domains with different firewall rules and what not, so linking al servers was not an option). I also created an XSD file (booooooooring), which I still need to link to all the tables I created in a central SQL (for now 2000) Server. So I have an x-amount of XML files in a folder, and I will need to import those one by one. So f...

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

SQl Server Error: ----> Named Pipes Provider, error: 40
  Hi Friends, Im using .Net2008 and MS SQL Server2005, I Have a web application , i want to connect to the server machine SQL Server,  When i run the application im getting the following error. Im trying to connect to the database from local machine application to server machine database   An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Cou...

Problems SQL Server -> SQL Anywhere
We have a strange problem when moving from MS SQL Server to SQL Anywhere. Can anyone help us with this problem Environment: Windows XP Sp1 Visual C++ 6.0 Adaptive Server Anywhere 8.0 ODBC driver 8.00.01.2600 Problem: I have derived a recordset class from CRecordset, and is using bulk row fetching. The data from the database is fetched in batches of 25 rows (default recordset size). If I terminate the operation when x rows are handled, the remaining (25-x) rows will turn up in the first batch when I restart the operation. All is well so far, but the first batch will hold ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

SQL > My SQL
I have a problem, my asp.net page wants to connect to the sql server, but it has to be the mysql. How can I solve this problem? This is my code: <%@ page explicit="true" language="VB" debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <%@ Import Namespace="System.Data.SqlClient" %> <html> <script runat="server"> sub page_load(sender as object, e as eventargs) If Not IsPostBack Then dim connect as sqlconnectio...

ISAPI dll -> App Server -> SQL database
Hello. I have some troubles with my Intraweb ( or may be not?) project. My Intraweb application ( ISAPI dll work under IIS 6.0 Windows Server 2003 Ent. SP2) connects to the Application Server. Application server is a windows service application with RemoteDataModule (Instancing: *ciMultiInstance* threading:*Apartment*). On RDM module i has one ADOConnection and set of ADOQueries, DataSetProviders. ADOConnection connects with MS SQL Server. Intraweb connects to the App Server by SocketConnection and has set of ClientDataSets. When client works with intraweb application in web brows...

Deploy Sql Server Express DB to Sql Server Express
I have developed by webite with Visual Studio 2005 and sql server express. I'm trying to deploy my website to a VPS with sql server express running on it I ftp'd the App_Data folder to the remote via the 'copy web site' Everything seemed okay until I started trying to run more complex database operations using stored procedures and transactions. It appears that the schema is messed up because when defining the parameters for a stored procedure, upon ExecuteNonQuery I get the error that I've assigned too many parameters which I have not (since it runs fine on...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

sql server and sql server express conflict
hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed" so i searched and searched then i found out that i cannot have the two ver...

Web resources about - SQL Server Express >>> SQL Server - asp.net.sql-datasource

Resources last updated: 12/24/2015 2:40:00 PM