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

Use migration script with Snapshots

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?
rickjr82
0

Comments

2 comments

Sort by
  • David Pond
    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-de ... tegration/

    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
    David Pond
    0
  • rickjr82
    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.
    rickjr82
    0

Add comment

Please sign in to leave a comment.