Install Application At Client PC which uses MSSql Server as Backend

I have one WinForm Application which using MS-SQL server As Database.

now off course Database i have created on my PC(Developer's PC) is not available on Client PC where i will install my Application.

Then what is the best criteria or practice to Add Database at Client PC's MS-SQL server.

So i can access it my 开发者_开发知识库Application.

Please Help.... Thanks.......

---

Depending on the actually size of the database, I would suggest you use SQL Conpact provider as you won't then need to worry about the whole setup process of installing SQL Server.

Good article to get started using Sql Compact

---

First you need to ensure that MSSql server is installed in the Clients PC. Assuming you have that taken care of, you could add Custom actions during installations which would execute the script to install the Database on the Client machine.

The exact way to do that of course depends on how you are creating the Installer Program.