CODEWITHSUNDEEP
c#sql-server
el ninho
el ninho

Reputation: 4233

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.

Upvotes: 1

Views: 91

Answers (2)

Aaron Bertrand
Aaron Bertrand

Reputation: 280340

You may want to look at SQL Server Compact, SQL Server Express or something like SQLite. I don't think any of these really offers a way to run a database engine without installing something or requiring something else to be installed (e.g. you could use AttachDbFileName method with SQL Server but this relies on VS/Express to already be there).

Upvotes: 1

Darin Dimitrov
Darin Dimitrov

Reputation: 1038900

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.

Upvotes: 5

Related Questions