Posts
Sort by recent activity
Problem with square brackets in SQL Prompt 6.5.0.326
SQL Prompt 6.5.0.326 does not appear to honor my choice regarding adding or removing square brackets.
My option setting on the Format>Actions page has the "Add/remove square brackets" checkbox blan...
Ignore table DEFAULT constraints completely?
I know that SQL Compare provides options to ignore constraint and index names, and to ignore CHECK constraints.
But, is it possible to ignore all DEFAULT constraints on table columns?
I have some d...
Find invalid objects: false positive on $PARTITION statement
SQL Prompt's "Find invalid objects" feature incorrectly flags the use of $PARTITION function/statement as invalid. (SQL Prompt 5.3.4.1)
Repro: embed any valid statement calling the $PARTITION stat...
Comparison filter files compatible between versions?
Can a comparison filter file, e.g., MyFilter.scpf, which was created in and written by SQL Compare 10.x be opened and used successfully by SQL Compare 9.x?
I am confident that the filter files are ...
Ignore merge replication constraints?
I would like to selectively ignore check constraints on table columns when the constraint name matches a pattern. The particular pattern is a check constraint name like [repl_identity_range_*].
My...
Find invalid objects: false positive on sp_upgraddiagrams
Using SSMS 2008 R2, I have added database diagrams to a SQL 2008 database. This invoked some scripts that added new system objects to my database to support the diagrams.
Now, SQL Prompt (5.1.16.3...
Key and Certificate script files fail comparison
Using the suggestion from another post in this forum (Compare schema between TFS Project with Database), I made a comparison between the "Scheme Object" file directory in my local TFS source tree a...
Scanning a set of snapshots for a particular change
I have established a routine daily task which takes SQL Compare 9 snapshots of a database, and stores them nicely in a folder. E.g., MyDB_20110601.snp, MyDB_20110602.snp, ..., MyDB_20110629.snp.
O...
My defaults vs Red Gate defaults. Sharing with team members.
Our team is just starting to use SQL Compare, and I have decided on a set of options that I would like all my team members to use. These are different than the Red Gate default options.
Where are ...
Updated help CHM file for SQL Compare 9.0?
The link on your main SQL Compare pages which offers to "download all topics as help file" points to http://www.red-gate.com/SQLCompare/latestCHM
This link downloads SQLCompare8_0.zip, which contai...