Posts
Sort by recent activity
Why so much unnecessary SQL for unchanged tables?
Not a big issue but I was wondering if it's posible to supress dropping/creating constraints for tables that have not changed.
We currently review the SQL scripts before they get released and it ma...
Should /include:missing reseed?
I'm trying to only INSERT data that exists in the source table but doesn't exist in the destination so I used the /include:Missing which seems to almost do what I want (via the command line).
It co...
IgnoreColumns only for existing rows?
Is it possible to ignore a certain column but only where a data row already exists?
For example, we create scripts during development with some basic data that can be customised in production. We d...
Incorrectly UPDATING excluded tables
Using SQLDataCompare command-line, I am specifically including a subset of tables however I am getting UPDATE statements for tables not in my list.
The tables are explicitly wrapped in \[Tablename\...
Adding NOT NULL columns to tables with data
Newbie question:
Can SQL Compare support the following for static data tables (by static I mean that the source database contains a superset of the data that is in the destination database and the ...