Comments
Sort by recent activity
There is the 'Use checksum comparison' option in SQL Data Compare which switches on roughly the mode you are looking for (although it does go ahead and do a full comparison on tables that turn out to be different rather than just leaving it at 'these are different').
This uses the built-in SQL Server implementation of CHECKSUM. We have amended the embedded help to say:
"Note that the built in SQL Server CHECKSUM is used. SQL Server CHECKSUM can occasionally fail to return different checksum values when the data sources differ. For more information, refer to your SQL Server documentation."
I have logged a feature request in our tracking system for the ability to perform a checksum comparison without performing a full comparison. / comments
There is the 'Use checksum comparison' option in SQL Data Compare which switches on roughly the mode you are looking for (although it does go ahead and do a full comparison on tables that turn out ...
Hi Jonathan
I just wanted to update this post for any other users experiencing an out of memory exception with SQL Doc when generating the documentation in Word format. This is a known issue with one of the third party components we use to generate the documentation with no suggestion as to when it might be fixed. It is logged in our tracking system with reference SDOC-1402. A possible workaround would be to generate individual documentation for each database. Alternatively, use HTML which does not exhibit the same behaviour. / comments
Hi Jonathan
I just wanted to update this post for any other users experiencing an out of memory exception with SQL Doc when generating the documentation in Word format. This is a known issue with ...
Many thanks for your suggestion. I have passed it over to the SQL Data Compare development team and they will consider it for a future release of SQL Data Compare. / comments
Many thanks for your suggestion. I have passed it over to the SQL Data Compare development team and they will consider it for a future release of SQL Data Compare.
Please see the following document regarding permissions for SQL Response: http://www.red-gate.com/support/Knowled ... _Setup.pdf / comments
Please see the following document regarding permissions for SQL Response:http://www.red-gate.com/support/Knowled ... _Setup.pdf
Thanks for your forum post. This feature has been requested by other customers and is logged in our tracking system. It will be considered by the SQL Doc team for a future release although we have no timescales for this at present. / comments
Thanks for your forum post. This feature has been requested by other customers and is logged in our tracking system. It will be considered by the SQL Doc team for a future release although we hav...
I have logged your feature request in our tracking system. This will be considered for a future release of SQL Response although we have no timescales for this as 1.3 is due out this week. / comments
I have logged your feature request in our tracking system. This will be considered for a future release of SQL Response although we have no timescales for this as 1.3 is due out this week.
If you would like to send me the file, I can get it put up on our CodePlex site. Please mail it to support@red-gate.com, quoting reference F0022336 in the subject. / comments
If you would like to send me the file, I can get it put up on our CodePlex site. Please mail it to support@red-gate.com, quoting reference F0022336 in the subject.
I have logged your feature request in our tracking system and it will be considered for a future release of SQL Doc although we have no timescales for this at present. / comments
I have logged your feature request in our tracking system and it will be considered for a future release of SQL Doc although we have no timescales for this at present.
In the meantime, you can do what you want using T-SQL:
DECLARE @CURRENT_DB NVARCHAR(128) ;
DECLARE @COUNTRY_CODE NVARCHAR(2) ;
SET @CURRENT_DB = DB_NAME() ;
SET @COUNTRY_CODE = SUBSTRING(@CURRENT_DB, LEN(@CURRENT_DB) - 1, 2) ;
SELECT @CURRENT_DB AS 'Current DB', @COUNTRY_CODE AS 'Country Code' ;
Let me know if this suits your requirements. / comments
In the meantime, you can do what you want using T-SQL:
DECLARE @CURRENT_DB NVARCHAR(128) ;
DECLARE @COUNTRY_CODE NVARCHAR(2) ;
SET @CURRENT_DB = DB_NAME() ;
SET @COUNTRY_CODE = SUBSTRING(@CURRENT_D...
Are you working over a VPN? We have a patch release to improve performance in these situations. / comments
Are you working over a VPN? We have a patch release to improve performance in these situations.