Create new DB from committed scripts

[mgaert]

Maybe I'm missing something obvious, but is there a way to create a new database from the committed scripts? The new app seemed so smart I thought maybe I would see a "Create from scripts" choice in the New Database dialog (there's a feature request!).

Thanks, I will definitely user this.

[sherr]

We currently don't store the CREATE DB script in source control. So, you just need to create a new db first as you normally would. This way you can specify size and locations in case machines are different. Then link this new db to source control on the setup tab. (Use the "Link to a db already in source control..." instead of the "Create link" on the Setup Tab.) Then get latest, which will bring your new db up to date with everything that was in source control.

You can vote/comment on this feature request at http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/459952-open-a-database-from-source-control?ref=title.

[mgaert]

Thanks, haven't tried it yet but that is the feature I was looking for.

[mgaert]

Tried it, worked great. It had a little problem with creating a role, but I just told it to slam through and it was all good. Thanks.