Deploying SQL Database

[wastebrain]

Hi All,

Can anyone tell me,is it possible to create an exe or msi for sql stored procedures,tabl es and triggers?I want to deploy the database objects(stored proc,tables,vie ws 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[:)]

[iburyak]

Usually database with all objects gets backed up and then restored on another Server. It is the best and safest way to do it.

You also can extract scripts of all objects and then run them on another Server using exe or any means which can connect to that Server.

Good Luck.