making setup project for app that works in local network

I wrote a WinForms app and it runs on the local network. My database is SQL Express, with multiple clients connecting to a central server.

I want to create setup project for my app. How do I create a setup project that:

1. When installed on the server, it creates my database?
2. When installed on the client, it only installs my appli开发者_开发百科cation without the database?

How do I create such a setup project, I am using VS2010 with the built-in setup and deployment features?

thanks.

What about creating two setup projects; one for the server and one for the clients?

I personally think, that there is not much you can do with the setup project in visual stidio.you may have to switch to third party to play with setups