CODEWITHSUNDEEP
c#.netvisual-studio-2010sql-server-2008sql-server-ce
Tabriz Atayi
Tabriz Atayi

Reputation: 6120

How to use database without installing it?

I have a database in SQL Server 2008. I want to deploy my software with CD. I want to give end user 2 choices :Use from CD and install it.

When end user selects the "Use from CD", I don't want install program. How can I do program execution without installing?

Please help me about this problem

Thank you for your attention. The program is coded In C# in MS visual studio 2010.Database Management system is MS Sql Server 2008

Upvotes: 3

Views: 4931

Answers (5)

Agnius Vasiliauskas
Agnius Vasiliauskas

Reputation: 11277

When running from CD - change database back-end - use simple Microsoft Access Db file with ADO ODBC connection. In such case - you will have almost same SQL language and no need to install something for access db (huh, maybe general odbc drivers if they not exists). When running from HD - switch db backend to full-scale MS SQL server ...

Upvotes: 0

Davide Piras
Davide Piras

Reputation: 44595

Use an embedded database which requires no setup and in-process execution, in your case best option is probably SQL Server Compact Edition

Edit: I know there are also other alternatives like BrekleyDb or SQLite but since Atayi is using SQL Server right now for his database, I suggested SQL Server Compact Edition to avoid any issue and stay on essentially the same technology/platform.

Upvotes: 12

Naval
Naval

Reputation: 344

You can "Silent Install " Sql server also, that way the client will not be bothered by the configuration of the server.

Upvotes: 1

Kevin
Kevin

Reputation: 11

First of all, I don't know if SQL Server '08 exists as a portable version, but if it burned on a cd, the use of a database is not there. The burned files cannot be changed :-)

A portable DBMS is SQLLite, there are bindings for C# :-)

Upvotes: 1

TomTom
TomTom

Reputation: 62157

Please help me about this problem

Don't use the technology you selected.

This is like saying "I want to drive a ferrari, but one that uses no fuel". Engines use fuel. SQL Server requires installation.

Alternative is SQL Server CE which you can load into the process.

THat is it. Run from CD is not possible without having SQL Server installed if you use SQL Server. Arguing wont change that.

Upvotes: 5

Related Questions