Building Schema and Data Diff Scripts
medi_pv
Posts: 8
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
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 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...
Currently I am doing this:
-- Instantiate two databases (we will call them A and
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
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...
Comments
That is, run the schema diff script before generating the data diff...