How to deploy c# windows application with sql server database

Hi,

if you developed using SQL server then you need to install it at client end.

How top deploy :

1. Now you can create a backup your DB and restore it at client's SQL server
2. If you using some ORM then your could generate you DB from it (but not store procedure and functions)
3. You can provide a script back up of your DB and ask client to run that on his sql server, you can patch the same within the exe and run those sql's on app start if tables not exists.

SQL Server backup Restore : http://msdn.microsoft.com/en-us/library/ms187048.aspx[^]

ORM (Entity Framework) Create DB : http://www.entityframeworktutorial.net/code-first/database-initialization-strategy-in-code-first.aspx[^]

Database SQL Script Generation : http://msdn.microsoft.com/en-IN/library/hh245282.aspx[^]

you can create setup project for your solution, using visual studio or something like install shield.
i suggest you if your application is capable using sql server express 2008 you can easily create setup project and makes your sql express bootstrap to install automatically on your clients systems using visual studio setup project. then create wizard for creation db and tables on your first start of your application on client side or copy your db then refer your connection string in your app.config.