Activity overview
Latest activity by Chris Auckland
SQL Search 2 released
We’re pleased to announce that SQL Search 2 has been released and is available to download from (http://www.red-gate.com/products/sql-development/sql-search/v2). This is a major release with...
SQL Search 2 released
We’re pleased to announce that SQL Search 2 has been released and is available to download from (http://www.red-gate.com/products/sql-development/sql-search/v2). This is a major release with...
Object Level Recovery Pro Latest Cumulative Patch
Patch to Red Gate Object Recovery Pro 1.2.0.24 - 07 Sep 2010
===================================================
This build of Object Recovery Pro should address the following issues in Object Reco...
SQL Compare 8 Latest Cumulative Patch
Patch to Red Gate SQL Compare 8.50.25.28 - 18 January 2011
===================================================
This build of SQL Compare should address the following issues in SQL Compare 8.50.12.1...
SQL Data Compare 8 Latest Cumulative Patch
Patch to Red Gate SQL Data Compare 8.50.25.47 - 1 December 2010
===================================================
This build of SQL Data Compare should address the following issues in SQL Data Co...
Thanks for your post.
Unfortunatly, as indexes are not treated as objects in their own right, you do not have the control to select which ones you want to ignore in the current.
We are planning to add this feature to the next major version of SQL Compare. For your reference the feature tracking code is SC-2447. / comments
Thanks for your post.
Unfortunatly, as indexes are not treated as objects in their own right, you do not have the control to select which ones you want to ignore in the current.
We are planning to ...
Thanks for your post.
The foreign keys are shown 'grayed' as they are not treated as objects in their own right, and cannot be checked or unchecked.
Once the tables are added to the diagram, you can select the table object and you will see the FK shown in the 'Dependencies' in the bottom right.
If you want to see the FK as an object on the diagram, you can select 'View' > 'Constraints as Objects'
I hope this is helpful. / comments
Thanks for your post.
The foreign keys are shown 'grayed' as they are not treated as objects in their own right, and cannot be checked or unchecked.
Once the tables are added to the diagram, you ca...
Thanks for your post.
The behaviour of the option should be consistent with the definition, so I'm not sure why it's working differently with your database. It seems to work as expected when I tested it.
Would you be able to send me the structure of the object that exhibits this behaviour and I will see if I can recreate the problem? / comments
Thanks for your post.
The behaviour of the option should be consistent with the definition, so I'm not sure why it's working differently with your database. It seems to work as expected when I test...
Thanks for your post.
Unfortunatly this still isn't possible. SQL Comapre will create the scripts based on the target database version, rather than the compatiability mode, as this is a much safer way of doing things.
SQL Comapre will always create the scripts in the format of the target database, so if the databse is a SQL 2005 in comp mode 80, it will create scripts that run on SQL 2005 in comp mode 80, not scripts for a SQL 2000 database.
However, we have an open feature request to allow the user to force SQL compare to create the scripts targeting a specific version, which I have asked the development team to review again. For your reference the feature tracking code for this is SC-3517.
As a workaround, you could sync the SQL 2005 comp mode 80 database to a SQL 2000 server, and then use the SQL 2000 database as the target for the scripts. / comments
Thanks for your post.
Unfortunatly this still isn't possible. SQL Comapre will create the scripts based on the target database version, rather than the compatiability mode, as this is a much safer ...
Oh ok, no problem.
The option your're looking for is:
Options.IgnoreKeys / comments
Oh ok, no problem.
The option your're looking for is:
Options.IgnoreKeys