Activity overview
Latest activity by urs.meili
Invalid Index specification leads to exception
Hi,
I have the following SQL script which SQL Compare is processing using the "compare with files" option:
CREATE TABLE [dbo].[tblMutationHistory]
(
[IDMutationHistory] [int] NOT NULL IDENTITY(1, 1...
it's ok for me. I discovered that the behaviour on the ALTER statements was very "weird", some of them will be considered, and some others won't. We will change our script sources to be consistent with V8. / comments
it's ok for me. I discovered that the behaviour on the ALTER statements was very "weird", some of them will be considered, and some others won't. We will change our script sources to be consiste...
> as we do not deal with ALTER TABLE etc commands at all.
this is also not true. We have lots of ALTER TABLE ... ADD CONSTRAINT commands in our scripts, and they work perfectly with SQL Compare 7.1. It is an absolute *must* that this type of commands still work with V8.0 / comments
> as we do not deal with ALTER TABLE etc commands at all.
this is also not true. We have lots of ALTER TABLE ... ADD CONSTRAINT commands in our scripts, and they work perfectly with SQL Compare 7.1...
Yes, indeed I would prefer 7.1 behaviour. The new behaviour means that our scripts suddenly don't work with SQL Compare anymore, as they used to do. Thus it means that 8.0 is not compatible with 7.1. This is a real "show-stopper" for us. / comments
Yes, indeed I would prefer 7.1 behaviour. The new behaviour means that our scripts suddenly don't work with SQL Compare anymore, as they used to do. Thus it means that 8.0 is not compatible with 7....
SQL Differences: Show only non-ignored differences
We ignore comments when we compare SQL scripts. If SQL Compare finds a relevant difference (which is not a comment), I want to seee the relevant item quickly, using the "SQL differences" window.
Cu...
this is not true. With SQL Compare 7.1, I have scripts which consist of ALTER VIEW statements. These will be included in the comparison with V7.1, but they are not in V8 / comments
this is not true. With SQL Compare 7.1, I have scripts which consist of ALTER VIEW statements. These will be included in the comparison with V7.1, but they are not in V8
Feature request: Ignore "WITH ENCRYPTION" option
On some DBs, we have WITH ENCRYPTION enabled, on some, we don't. I would like to have an option "IGNORE WITH ENCRYPTION". If this is turned on, SQL Compare should not care if WITH ENCRYPTION is spe...
ALTER<space><space>VIEW not recognized
It seems like Sql Compare 8 does not recognize ALTER VIEW, ALTER PROCEDURE etc statements if there are multiple spaces in between. This was no problem with Sql Compare 7.