Deploy data base with setup project

Hi can some body help me please? I'd like to know how to开发者_如何学运维 add a sql script to a setup project, so that after the instalition the data base is implémented? I mean that the setup project implement the data base that I add it to the setup project with the sql script I'm using c#, wpf, SQL SERVER2008, VisualSutdio 2008 thank's

I have worked with SQL CLR projects in visual studio that use \Scripts\Pre-Deployment and \Scripts\Post-Deployment folders to do exactly what you describe. In your case, try adding a database project type to your solutions. You should should be able to add the scripts needed to create the database and add objects. Here is a link