SQL Compare - 8.0
Troubleshooting & error messages
SQL Compare
- Exit codes used in the command line [Learning topics]
- Comparing databases on different SQL Server versions [Learning topics]
- Comparing databases on unconnected SQL Servers [Learning topics]
- Creating a rollback script [Learning topics]
- Warnings [Learning topics]
- Logging and log files [Knowledge base]
- Stored Procedures and Functions created with wrong name [Knowledge base]
- Extended properties not permitted error (version 5.2) [Knowledge base]
- CLR Procedures' permissions are not recreated (version 5) [Knowledge base]
- Support for 'returns NULL on NULL Input' in CLR functions (version 5) [Knowledge base]
- Project files (scp files) suddenly appear on desktop (version 5) [Knowledge base]
- Stored procedures using full-text queries fail to synchronize [Knowledge base]
- Unable to begin a distributed transaction error synchronizing databases [Knowledge base]
- User or role already exists in the current database error [Knowledge base]
- Clarification on the "Ignore Triggers" option in the SQL Compare command-line version [Knowledge base]
- Common table expressions returned by User Defined Functions may fail [Knowledge base]
- Can't compare encrypted text in SQL Server 2005, 2008 [Knowledge base]
- Exception when connecting to SQL Server (Version 6) [Knowledge base]
- Using Team Foundation Server source control system [Knowledge base]
- Index was outside the bounds of the array error when registering databases X64 [Knowledge base]
- HTML reports are generated for identical comparisons [Knowledge base]
- Comparison may seem slower than necessary [Knowledge base]
- DEFAULT_SCHEMA clause cannot be used with a Windows group [Knowledge base]
- SQL Compare may drop and create CLR assemblies [Knowledge base]
- SDK activation prompt may appear when starting a new SQL Compare project [Knowledge base]
- Column does not allow nulls. INSERT fails [Knowledge base]
- This SQL Server has been optimized for x concurrent queries. [Knowledge base]
- SQL Compare comparison differences [Knowledge base]
- Invalid SQL when synchronizing an index to a scripts folder when data compression is specified [Knowledge base]
- Common error messages [Knowledge base]
- Copying the structure of a database [Knowledge base]
- Permissions required to use SQL Compare [Knowledge base]
- Rollback on script failure or cancellation [Knowledge base]
- Errors in scripts folders [Knowledge base]
- Logging and log files [Knowledge base]
all SQL products
- Application has encountered an error and needs to close [Knowledge base]
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found. [Knowledge base]
- Login failing with "trusted SQL Server connection" error when using RunAs [Knowledge base]
all products
- Troubleshooting Check for Updates errors [Notes & articles]
- No response received for manual activation [Notes & articles]
- Licensing and activation resources [Notes & articles]
- Licensing and activation resources [Notes & articles]
- Troubleshooting licensing and activation errors [Notes & articles]
- Red Gate tools log file locations [Notes & articles]
- Some Red Gate products identified as containing a trojan by Anti-Virus software [Knowledge base]
- Product uses web help although a CHM file is available locally [Knowledge base]
- The application UI opening slowly when there is no internet access [Knowledge base]
Search support
Forums
Visit the SQL Compare forum.
Using SQL CompareSQL Compare
- Logging and log files
- Stored Procedures and Functions created with wrong name
- Synchronization scripts may be in incorrect version of SQL syntax
- Extended properties not permitted error (version 5.2)
- CLR Procedures' permissions are not recreated (version 5)
- Support for 'returns NULL on NULL Input' in CLR functions (version 5)
- Project files (scp files) suddenly appear on desktop (version 5)
- Stored procedures using full-text queries fail to synchronize
- When does the synchronization process rebuild tables?
- Unable to begin a distributed transaction error synchronizing databases
- User or role already exists in the current database error
- Clarification on the "Ignore Triggers" option in the SQL Compare command-line version
- Common table expressions returned by User Defined Functions may fail
- Can't compare encrypted text in SQL Server 2005, 2008
- Exception when connecting to SQL Server (Version 6)
- SQL comparison and synchronization automation capabilities
- Error logging in SQL Compare 6.2
- Using Team Foundation Server source control system
- Creating a SQL 2000 compatible database from a SQL 2005 database using SQL Compare
- Support for numbered stored procedures
- SQL Compare 7 Object-level restore
- Index was outside the bounds of the array error when registering databases X64
- HTML reports are generated for identical comparisons
- Comparison may seem slower than necessary
- DEFAULT_SCHEMA clause cannot be used with a Windows group
- SQL Compare may drop and create CLR assemblies
- SDK activation prompt may appear when starting a new SQL Compare project
- Column does not allow nulls. INSERT fails
- This SQL Server has been optimized for x concurrent queries.
- SQL Compare comparison differences
- Using SQL Server Management Studio Express as a query editor
- How to force SQL Compare and SQL Data Compare to use an Encrypted Connection
- Invalid SQL when synchronizing an index to a scripts folder when data compression is specified
- Tips
- Changes to distribution of command line
- Common error messages
- Copying the structure of a database
- Permissions required to use SQL Compare
- Rollback on script failure or cancellation
- Errors in scripts folders
- Logging and log files
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Compare
- Activating your products
- Activating your products
- Getting help offline
- Release notes - version 9.5 EAP
- Introducing SQL Compare 8: FAQs for SQL Compare 7 users
- Release notes - version 10.xx
- SQL Compare release notes - version 9.xx
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
