pnp

Hi

Is it possible to create a setup project in Visual Studio, to be able to deploy your database

If yes, how do I set this up

I would like to end up having a MSI installer, that when executed installs my entire database on a given database server.

Best regards

Anders



Re: Visual Studio Team System - Database Professionals Setup project for a database project

Amos Soma

Anders,

I don't think DBPro can do this (someone from Microsoft can correct me on this). However, Red-Gate has such a product (http://www.red-gate.com/products/SQL_Packager/index.htm). Note, DBPro can create the entire script to create and deploy your database but I don't believe it has the capability to create an .MSI.

Amos.





Re: Visual Studio Team System - Database Professionals Setup project for a database project

StevenPo - MSFT

That's correct, Amos. We do not support that in this version of the product. One of the team members is investigating build and deployment for our next release. I'll loop him in on this thread if you have specific requirements that you'd like to pass along.

thanks,






Re: Visual Studio Team System - Database Professionals Setup project for a database project

Duncan Davenport

Indeed, and I am that member! Anders, this is an approach that we are actively investigating for our next release. The basic requirement as you stated it is definitely on our radar - if there are additional features related to this that you feel merit consideration, please let us know!

Duncan Davenport
VSTS.DBPro | Program Manager






Re: Visual Studio Team System - Database Professionals Setup project for a database project

pnp

Thanks for your replies.

I'm glad to hear that you are working on it - good luck with that.

I do not currently have any further feature requests. Off course once you get your database deployed there are all the questions on how to update the database without destroying data, firing triggers, notifications etc.

But the most basic things I would find nice to have is:

1. Basic deployment of the database. This means first time installation.

2. Update. If I have changed the schema, added programmability or removed something, then it would be nice to be able to generate a "patch" msi. So when I install 1.0.1 of my database on top of 1.0.0 these changes will be executed.

Best regards

Anders