http://blogs.msdn.com/b/bahill/archive/2010/05/04/leveraging-the-visual-studio-2010-database-deployment-api.aspx
The same functionality can be achieved using sqlcmd.You can execute these sql scripts created using sqlcmd (sqlcmd gets installed when SQL Server 2005/2008 is installed).
I guess same results can be achieved with VSDBCMD also.Never tested that :-).
Now things looked challenging when I had to insert data in some tables while deploying the database projects.In simple words if the database is deployed it should create database,database objects also it need to insert some data in master tables.
Thereafter I found out you can put all your insert statements in Post Deployment Script File.The database projects in VS 2010 will have a file Script.PostDeployment.sql , just put your insert or delete statements in that file and when you deploy the project it will insert data in master tables.
Gr8 experiment with VS2010..
ReplyDelete