Posts
Sort by recent activity
Very slow "Reading Indexes"
Why does my SQL Compare 14.2.9.15508 take multiple minutes to read indexes when comparing two SQL Server 2019 databases? The rest of the process is quick, but reading indexes is painfully slow. I t...
Data compare columns not adjacent
The SQL Data Compare results showing differences are
supposed to show the two columns being compared adjacent to each other.
Sometimes the columns are not adjacent to each other, making it hard to ...
Bottlenecks / Optimization?
SQL Data Compare can be very slow on large databases, sometimes taking hours to determine the differences (over a VPN connection). What are the common speed bottlenecks? My guess is that the networ...
How to ignore [brackets]?
One of the most common differences I see is object names having brackets on one server and not the other. [dbo]. = dbo.table.
Ultimately I would like to know what keeps adding the brackets back, b...
Table insert order precedence setting?
Is there a feature I am overlooking in DataCompare 7.1 that would allow me to set a table insert order precedence constraint? For example, when synchronizing the ASP.NET user accounts tables I woul...
ALLOW_PAGE_LOCKS index attribute
For the ALLOW_PAGE_LOCKS=ON|OFF attribute of indexes in SQL Server 2005, SQL Compare recognizes the differences, but will not synchronize these differences. If you add this attribute to an index in...