SQL Server database or database on SQL Server
NickName:el ninho Ask DateTime:2012-04-17T05:34:56

SQL Server database or database on SQL Server

I'm writing windows application which will be used on one computer. I like to do with SQL server, retrieve data with stored procedures, and so... My question is, what is the difference between SQL server database (in file) and standard db on SQL server, because I don't want to install SQL server on client's PC just for one app. Can be this SQL server DB used with stored procedures, or is there other way?

Thanks.

Copyright Notice：Content Author:「el ninho」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/10182041/sql-server-database-or-database-on-sql-server

Answers
Darin Dimitrov 2012-04-16T21:39:28

If you don't want to install a full SQL Server engine on the client machine you could use an embedded database such as SQL Server Compact or SQLite which are designed for those scenarios.",

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “SQL Server database or database on SQL Server” related questions
SQL Server database or database on SQL Server

I'm writing windows application which will be used on one computer. I like to do with SQL server, retrieve data with stored procedures, and so... My question is, what is the difference between SQL ...

Show Detail
SQL Server Database

If I make an SQL server database, 1) Do I need to install SQL server on client's machine too to use it in vb.net or we can use it just without it, as Access database can be used in vb.net. 2) I

Show Detail
Azure, SQL Server and Database

One of my customer is developing multi-tenant solution. And I'm working as developer for the automation of resource provisioning part. The solution is developed such that each tenant have their res...

Show Detail
Convert SQL Server Express database to SQL Server Compact database

How can I convert a SQL Server Express database to a SQL Server Compact edition database with minimum deployment by using coding?

Show Detail
Convert SQL Server database to SQL Server CE?

I have a SQL Server database which I can read from, is there a quick way I can turn it into an SQL Server CE database through C# or will I have to read in all the data then output it in SQL Server CE.

Show Detail
Is SQL server's database a sql database?

I need some clarification on databases and backend. I am currently using microsoft sql server with a database connection. Does that mean, that the sql server uses an sql database? Or is it using a

Show Detail
Copy data from on-premises SQL Server database to Azure SQL Server database

I have two SQL Server instances, one being an on-premise SQL Server and the other being Azure SQL Server instance. Some of the tables in the Azure SQL Server database have a few columns which contain

Show Detail
Drop SQL Server Database

I am creating a SQL Server database programmatically during a conversion. If the conversion code fails I want to delete/drop the database. If I use the shortcut menu for the database in SQL Server

Show Detail
Compatibility level for SQL Server database

My database hoster allows to restore SQL Server databases with a compatibility level of 90 (SQL Server 2005). My database is created locally with a compatibility level of 100 (SQL Server 2008). ...

Show Detail
SQL Server database connection

I have an ASP.net web application and a database created on another computer. Now I want to run this on my computer. I have installed SQL Server Express edition and SQL Server Management Studio o...

Show Detail