how to publish winforms app?

Agree with @Amit Gupta, Yes you need to install sql server at client machine manually or while creating setup file you can add sql server as prerequisite so while installing your application sql server will install you may need internet connection. you can genarate script of your database and run it in client sql server, later if want to update client database you can take use of DbUp.

thanks all.