How to deploy the database

Hi All,

Can anyone tell me,is it possible to create an exe or msi for sql stored procedures,tables and triggers?I want to deploy the database objects(stored proc,tables,views and functions) as an exe file..just like publishing and deploying the asp.net application.Is it possible for sql server database objects.Pls,let me know.

Thank U

You can generate scripts for them. Right click on db - > All Tasks -> Generate Scripts.. follow the wizard.

|||

I know that.But is it possible to create exe or msi package for the sql objects.just like deploying the asp.net application

|||

I'm sorry.I forgot to tell you(Dinakar).Thank You.

|||

There is an osql utility to compile the scripts from a file..