Red Gate forums :: View topic - Use migration script with Snapshots
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Use migration script with Snapshots

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rickjr82



Joined: 22 May 2013
Posts: 14

PostPosted: Wed May 22, 2013 3:05 pm    Post subject: Use migration script with Snapshots Reply with quote

We have a process where we are creating snapshots based on check-ins to SQL source control and then picking a version to deploy and using sql compare to deploy that snapshot to the target database.

It appears that deploying from a snapshot doesn't pick up any migration scripts- am I missing anything?
Back to top
View user's profile Send private message
David Pond
Site Admin


Joined: 06 Mar 2012
Posts: 16
Location: Cambridge, UK

PostPosted: Fri May 24, 2013 11:00 am    Post subject: Reply with quote

Snapshots only capture the database schema, so the addtional migration information is not available when comparing snapshots.

The current implementation of Migrations requires a connection to your version control system. To generate a deployment script that includes your migrations you should compare revisions from SQL Source Control that are equivalent to the state of the deployed database.

You might find some of the resources on this page interesting: http://www.red-gate.com/products/sql-development/automation-license-for-continuous-integration/

I'm working on revising our approach to migrations at the moment, to improve branching and support Git and Mercurial. I'd love to get your feedback if you have time - I'll send you an e-mail.

David Pond
Software Engineer
Back to top
View user's profile Send private message
rickjr82



Joined: 22 May 2013
Posts: 14

PostPosted: Fri May 24, 2013 1:42 pm    Post subject: Reply with quote

Sounds good, I sent you a PM with contact and more general information.

Once we get this finalized, I will provide a write up and share with the group on a solid CI->automated deploy process.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group