Is SQL Server Compact ever OK to use on a web server?

Posted by Troy on Stack Overflow See other posts from Stack Overflow or by Troy
Published on 2010-06-10T06:08:49Z Indexed on 2010/06/10 6:12 UTC
Read the original article Hit count: 181

Filed under:

sql-server-ce

|

sql-server-compact

I'd like to host a personal database for about 500 people (1 database per person) on my web server. A person could possibly share their database with a friend or two. On my web server, I'd have some web services, perhaps for doing synchronization, and maybe even an ASP.NET Web Forms front end to the database.

If I restart my IIS web server, would this likely cause database corruptions? Would this be expected to perform ok?

If not Compact, should I instead use SQL Express and create a database in SQL Server for each of my 500 people?

© Stack Overflow or respective owner

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
Slow Update/insert into SQL Server CE using LinqToDatasets

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is… >>> More
SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

as seen on Stack Overflow - Search for 'Stack Overflow'
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml. The result was an error: "The selected object(s) are an unsupported data provider" This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about… >>> More
SQL Server 2005 Merge Replication to SQL Server CE 3.5

as seen on Server Fault - Search for 'Server Fault'
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking… >>> More

Related posts about sql-server-compact

Visual Studio 2008: Don't deploy SQL Server Compact 3.5 when debugging

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using VS2008 to create a Compact Framework application for a Windows CE 5.0 device (Datalogic Kyman). I'm using SQL Server Compact 3.5 in my application. However, I'm debugging on a Kyman that still has Windows CE 4.2 installed (attached via USB using Mobile Device Center). My problem: VS2008… >>> More
Print DataBase Schema in Sql Server Compact Edition

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it? >>> More
SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5

as seen on SQL Authority - Search for 'SQL Authority'
There are few downloads released for Microsoft SQL Server Compact 3.5. Here is quick lists of the same. Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and… >>> More
SQL SERVER – Download Microsoft SQL Server Compact 4.0 SP1

as seen on SQL Authority - Search for 'SQL Authority'
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 is the default database for Microsoft WebMatrix. For enhanced development and debugging capabilities, including designer… >>> More
Connect to SQL Server Compact Edition in SSIS

as seen on Stack Overflow - Search for 'Stack Overflow'
Till now I've been exporting data INTO the SQL Server CE database, but now in SSIS I'm attempting to source data that was inserted in a previous step of the import. The SSIS fails during validation with the following error Error: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException:… >>> More