I am creating a window application on c# .net and Sql Server 2008 R2. I will give the setup of this application to my client but I am little bit confuse about SQL Server Database. How the database is given to client, if I will restore my database in sql server environment on client PC then it will be easily updated/truncated by sql commands. So is there any other option to set up database to client pc that will work offline(without internet) or without installing sql server environment.
migration rejected from stackoverflow.com Nov 30 '13 at 12:58
This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.
closed as unclear what you're asking by Mark Storey-Smith, RolandoMySQLDBA, Max Vernon, bluefeet♦, Marian Nov 30 '13 at 12:58
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.
No. You use a server technology, you need a server installed somewhere where teh database runs on. Don't want that - USE ANOTHER TECHNOLOGY (SqlServer Embedded for example, or one of the alternatives).
A restore generally is not a good idea. The normal approach is to generate a empty database then maintain if from there (as in: setup scripts). Same mechanism also handles updates. And give the user a chance to configure the database as he wants, unless you have a trivial project.
Generally don't ask like you never saw software using sql server. If you ever install a software doing so (Sharepoint for example, WSUS) you can see how their installers handle that and this is generally a good approach.
But yes, you need SQL Server installed somewhere to use it. In one version (Express is free).