Comments
Sort by recent activity
An option to generate if exists drop then create for triggers, procedures, functions, etc.
The compare to script option writes the script as create procedure, etc.
I love your tools - keep up the good work! / comments
An option to generate if exists drop then create for triggers, procedures, functions, etc.
The compare to script option writes the script as create procedure, etc.
I love your tools - keep up the g...
I am having this issue with one server in version 1.7.4.1062. It was working fine then it started with this error. Deleted it and re-added it and it connected and then when I tried to categorize it the error resumed.
Update - seems related to the filter - continuing to research / comments
I am having this issue with one server in version 1.7.4.1062. It was working fine then it started with this error. Deleted it and re-added it and it connected and then when I tried to categorize it...
I see the same result in both the side by side window in SQL Compare and in the toolkit looking at the text property (of the stored procedure) in the difference object. / comments
I see the same result in both the side by side window in SQL Compare and in the toolkit looking at the text property (of the stored procedure) in the difference object.
SQL Compare version is 5.2.032
both source and target db servers are
SQL Server is Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Collation is SQL_Latin1_General_CP1_CI_AS / comments
SQL Compare version is 5.2.032
both source and target db servers are
SQL Server is Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Collation is SQL_Latin1_General_CP1_CI_AS
I am seeing similar behavior with 10.2 using XML
<options>IgnorePermissions,IgnoreFillFactor,IgnoreUserProperties,ForceColumnOrder,IgnoreStatistics,IgnoreUsers,IgnoreReplicationTriggers,IgnoreExtendedProperties,IgnoreFileGroups,IgnoreWhiteSpace</options>
...
<exclude>Schema</exclude>
<exclude>Role</exclude>
<exclude>User</exclude>
...
<reportAllObjectsWithDifferences />
report shows
Role db_owner == ==
Role db_accessadmin == ==
Role db_datareader == ==
Role db_datawriter == ==
Role db_ddladmin == ==
Role db_securityadmin == ==
Role db_backupoperator == ==
Role db_denydatareader == ==
Role db_denydatawriter == ==
Role public == ==
Schema db_owner == ==
Schema db_accessadmin == ==
Schema db_datawriter == ==
Schema db_ddladmin == ==
Schema db_securityadmin == ==
Schema db_backupoperator == ==
Schema db_denydatareader == ==
Schema db_denydatawriter == ==
Schema INFORMATION_SCHEMA == ==
Schema dbo == ==
Schema guest == ==
Schema sys == == / comments
I am seeing similar behavior with 10.2 using XML
<options>IgnorePermissions,IgnoreFillFactor,IgnoreUserProperties,ForceColumnOrder,IgnoreStatistics,IgnoreUsers,IgnoreReplicationTriggers,IgnoreExten...