Activity overview
Latest activity 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... / comments
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 ...
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 from two DACPACs
-- Build the schema di...
Data Loss Check in Script
I'm using the SDK to generate schema and data compare scripts.
The current system we use is from visual studio. When something occurs that will cause data loss (like dropping a column), the script...
Nevermind, I figured out what I was doing wrong. I had a database object registered for both schema and data compares. Which seems to mess things up... / comments
Nevermind, I figured out what I was doing wrong. I had a database object registered for both schema and data compares. Which seems to mess things up...
Assembly Difference Not Appearing in Update Script
I am using Database.CompareWith to get schema differences between two databases.
In the result differences, I see there is an 'assembly' that is different. I also confirm this in the SQL Compare U...