We use this product to script changes to our databases.
http://www.red-gate.com/sql/SQL_Compare_facts.htmIt is an excellent product. Along with SQL Data Compare you can script changes to the structures, etc.. you can script data itself if you need to distribute metadata, etc..
From what I understand the lastest Wise installer will handle these tasks as well.
Hope this helps.
Tommy
>Hi All,
>
>I understand .NET web application installations are supposed to be easy, but we are running into several issues. One of which is dealing with SQL Server database changes. Is there a SQL Server tool out there like SDT?
>
>Also, what are the procedures of creating installation CDs for .NET web applications with a SQL server backend? Can one use WISE or INNO do do these things? What about setting up IIS?
>
>I'm just trying to find out what the "masses" are using or the procedures to creating .NET web app installs.
>
>Thanks,
>Jacci