Posts
Sort by recent activity
Tab History - Crashing
I recently opened a large (16MB) SQL script in SSMS 2014 and now whenever I try to view the Tab History SQL Prompt (6.3.0.354) crashes with an out of memory error and the Tab History window remains...
Fulltext Indext Stoplist Options
When comparing a table script file containing a full text index definition with another script file with an equivalent fulltext definition but where the STOPLIST option is included, then SQL Compar...
Snapshot vs Database Comparison and Extended Properties
I'm experiencing an issue when comparing a snapshot vs the database that the snapshot was generated from whereby a difference is indicated in the main window but where there are no differences high...
Prompting to Create New Database with SQL Server 2000 Target
When performing a comparison where the target is an existing database attached to a SQL Server 2000 instance then I am prompted to create a new database when clicking 'Compare Now' on the 'New Proj...
Source / Target Selection Window Issue
I've downloaded and installed the latest release of SQL Compare.
SQL Compare 10.0.0.140 Professional Edition running on Windows 7 Enterprise 64-bit.
All seems well apart from the Source / Target se...
Failing to Acknowledge DATA_COMPRESSION Diffs at Table Level
I have found an inconsistency whereby SQL Compare (9.0.0.79) fails to acknowledge (at the table level) differences in the DATA_COMPRESSION option setting for indexes - the relevant tables on both s...
SQL Compare XML Output File Encoding
It would be useful to be able to specify the encoding of the XML comparison output report when running SQL Compare 9 from the command line.
It appears that the encoding of the XML output report is ...
CREATE PROCEDURE ignored if script contains CREATE LOGIN...
SQL Compare 8.2.1.70 fails to parse the following CREATE PROCEDURE statement when contained within a script file (a 'High' severity error is listed in the 'Error Parsing Scripts' window):SET QUOTED...
Feature Request : Add Custom Code to Synchronisation Script
It would be nice to have the facility to add custom code into the generated synchronisation script, and for the code to be wrapped in the transaction and error handling
For instance, we use SQL Com...
DML Trigger Folder
Is it possible, when scripting a database using SQL Compare, to specify that DML triggers be created on a one-script-file-per-object basis?
Currently trigger definitions are appended to the table s...