Create new DB from committed scripts

Early Access Program for SQL Source Control

Moderators: Chris Auckland, David Atkinson, sherr

Create new DB from committed scripts

Postby mgaert » Thu Mar 25, 2010 6:41 pm

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
 
Posts: 9
Joined: Wed Jan 09, 2008 10:22 pm
Location: NYC

Create new DB from committed scripts

Postby sherr » Fri Mar 26, 2010 12:04 pm

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.
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby mgaert » Fri Mar 26, 2010 1:48 pm

Thanks, haven't tried it yet but that is the feature I was looking for.
mgaert
 
Posts: 9
Joined: Wed Jan 09, 2008 10:22 pm
Location: NYC

Postby mgaert » Fri Mar 26, 2010 4:25 pm

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
 
Posts: 9
Joined: Wed Jan 09, 2008 10:22 pm
Location: NYC


Return to SQL Source Control EAP

Who is online

Users browsing this forum: No registered users and 0 guests