CODEWITHSUNDEEP
wpfinstallationclickonce
techjourneyman
techjourneyman

Reputation: 1813

Deploy application and database in WPF

I have a WPF application and it has a SQL Server database. All users of the application will be able to do the following:

  1. Be able to install the application locally, and also the database (blank tables with no data) using a single click. Henceforth they will be able to run the application locally on their own machines. All the users have SQL Server installed on their machines.

  2. Be able to get updates (or notification of updates) on the application and database, and will be able to install the updates if they choose to do so.

I realize that ClickOnce can do it for the application only. Now since I have the database along with the application, how can I do it?

Any help will be greatly appreciated.

Upvotes: 1

Views: 1527

Answers (2)

Eilistraee
Eilistraee

Reputation: 8290

If your users have the adequate permissions over their database (which I hope they have) you could simply check that the DB is ready at application Startup, and if not, run the creation scripts on it.

Upvotes: 1

basarat
basarat

Reputation: 276303

You can deploy an SQL Server compact database along with your application. Sample here: http://robindotnet.wordpress.com/2010/02/28/how-to-deploy-the-sqlserver-compact-edition-software-locally/
For SQL Server 2005 / 2008 the user must use the Microsoft provided installers.

Upvotes: 0

Related Questions