How can we help you today? How can we help you today?

Create new DB from committed scripts

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.
mgaert
0

Comments

3 comments

Sort by
  • StephanieHerr
    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/390 ... ?ref=title.
    StephanieHerr
    0
  • mgaert
    Thanks, haven't tried it yet but that is the feature I was looking for.
    mgaert
    0
  • 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.
    mgaert
    0

Add comment

Please sign in to leave a comment.