Activity overview
Latest activity by mikeATCompuware
It appears it is not a bug, but rather a limitation of SQL Server 7. SQL Server 2000 allows this view creation, and SQL Server 7 does not. So this type of error only happens when sync'ing from 2000 to 7. I'm not sure how you address other incompatabilities, but perhaps raising a warning would help. / comments
It appears it is not a bug, but rather a limitation of SQL Server 7. SQL Server 2000 allows this view creation, and SQL Server 7 does not. So this type of error only happens when sync'ing from 2000...
I agree with your 'best practice', however I'm sure there are lots of other people like myself who get handed a code base they did not develop and which is not all consistant. Off all the issues I've been having with SQL Compare creating scripts to can actually run, this one has been the most painful for me in terms of debugging and rewriting the scripts. / comments
I agree with your 'best practice', however I'm sure there are lots of other people like myself who get handed a code base they did not develop and which is not all consistant. Off all the issues I'...
Agreed, it probably could be considered a bug, but it is all these small issues that I've encountered that has made me have to spend lots of time diagnosing the errors and rewriting the scripts I get from SQL Compare. / comments
Agreed, it probably could be considered a bug, but it is all these small issues that I've encountered that has made me have to spend lots of time diagnosing the errors and rewriting the scripts I g...
Object name to Definition mismatch
There appears to be an issue when syncing objects where the underlying definition does not match the object name.
For instance, you have a view object named v_users and its definition is:
create vi...
Views with Order By not in Select List
I noticed that if you have a View which has an item in the Order by list, but not in the select list the script will error out. For example:
CREATE VIEW user.view
AS
SELECT TOP 3 Id, Naam, Host, Wo...
Views that include Select *
I'm not using the 'Include dependent database objects'. However, I ran into the following situation:
Underlying table changes (column added)
> View references the table with 'Select *' statement, b...