CODEWITHSUNDEEP
c#sql-serverwinformsinstallation
user1934161
user1934161

Reputation: 15

application with setup file with out SQL Server database

I have a windows application which is uses SQL Server as its database. For this application I want to create a setup file for other desktops, but I don't want to install SQL Server on each and every client.

Can you please suggest how to create Windows application with local storage setup file without installing any databases or framework libraries?

Upvotes: 0

Views: 777

Answers (2)

slugster
slugster

Reputation: 49965

You don't need to install SQL Server on each client - you can simply install it on a central server then all the clients can connect to and use the same instance.

If this is not a good option because each client must have its own storage locally then you can look to use something like SQL Server Compact, which is a very cut down version of SQL Server that doesn't require installation and runs inproc.

Upvotes: 1

Paul Fleming
Paul Fleming

Reputation: 24526

You can use SQL Server Compact. The database is stored in a file that you carry with the product rather than requiring a database server.

If this is just for "settings" then consider storing it in the user's application data as a simple XML file.

Upvotes: 1

Related Questions