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

Building Schema and Data Diff Scripts

I've been working on a utility to build both a schema and data diff script.

Currently I am doing this:
-- Instantiate two databases (we will call them A and B) from two DACPACs
-- Build the schema diff between A and B
-- Build the data diff between A and B

I am seeing that for columns or tables that have been added, they are not showing up in the data diff script. I was thinking about this and wondering if I really should be doing the following.

-- Instantiate two databases (we will call them A and B) from two DACPACs
-- Build the schema diff between A and B
-- Run the schema diff on the target database
-- Build the data diff between A and B

Sorry if this is obvious or if I've missed something. I new to RedGate and the SDK...
medi_pv
0

Comments

1 comment

Sort by
  • medi_pv
    So after doing some experimentation and talking with a few other people with more experience. The modified process is the way to go.

    That is, run the schema diff script before generating the data diff...
    medi_pv
    0

Add comment

Please sign in to leave a comment.