0

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?

Improve this question
1
  • You shouldn't indent your paragraphs with spaces like a letter, here it gets treated as a code block. Commented Dec 28, 2012 at 10:02

2 Answers 2

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.