x

Working on Database without install SQL Server

Dear all,

I have a question please?

In my company they decide to design a program to insert some data so we use asp as an interface. but with database is the problem..this program will install on 1200 pcs locally.and they don't want to install SQL server on these pcs ..the company decide if there is no other solution to use access 2007 as database and asp.net as interface(but I don't like access. can we attached the file data with web application and work on it without install SQL Server....

I heard there is a compact SQL to this work....is this right ?

Any idea any suggestion ? plz
more ▼

asked Sep 18 '12 at 03:27 PM in Default

Troy_2012 gravatar image

Troy_2012
750 19 27 36

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You have several options, depending on what you are trying to do. The first thing to ask is: Do you want each of these 1200 pcs to have their own instance of the database? Very frequently each PC will have its own instance of the client software, but that client software will connect to one (or a few interconnected) servers that run SQL Server and manager the databases.

If you want each one to have its own database, then SQL Server Express is probably what you want. SQL Server Express is a light weight, generally free (as in without cost, not open source) version of SQL Server that is meant to run on a desktop. It is great for study, light testing, or to serve as the backend for local applications. There are a couple of different versions of SQL Server Express and localDB is a light version of express that runs in user space. It seems to be exactly what you want.

Just for the sake of being comprehensive, I'll add that SQLite is another light weight database management system designed to run in user space and generally meant to support single user applications. I generally prefer SQL Server Express, but it is good to have options.

more ▼

answered Sep 18 '12 at 04:58 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.5k 19 22 32

Thanks TimothyAWiseman ,

I'm going to use SQLite.
Sep 18 '12 at 05:44 PM Troy_2012
It is a very good option. I have used it for several projects and been very happy with it.
Sep 18 '12 at 08:12 PM TimothyAWiseman

And another good option could be Firebird Embeded. When deploying it is a single Dll which is going with your application without any additional installation.

Jun 20 '13 at 05:06 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
As an addition to @TimothyAWiseman's answer, this is a nice comparison of SQL Express, localdb and Compact Edition: http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx
more ▼

answered Jun 19 '13 at 08:46 PM

tomgough79 gravatar image

tomgough79
1.7k 7 14 16

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x66

asked: Sep 18 '12 at 03:27 PM

Seen: 1298 times

Last Updated: Jun 20 '13 at 05:06 AM