Activity overview
Latest activity by sebling
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 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...
ALTER index vs DROP when alter is possible
When changing rebuild index options e.g. ALLOW_PAGE_LOCKS is it possible for SQL Compare to generate an ALTER INDEX REBUILD WITH rebuild index options rather than a drop and create?
Would simplify ...
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...
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 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.
Difference object text has different character than QA
I have the following string in a stored procedure:
"Error - Format Error - Invalid Branch Access" ErrorField="0"
SQL Compare shows the text as:
"Error – Format Error – Invalid Branch ...
Drop Index Option
We are using the toolkit to generate migration scripts to different environments.
Without having to parse through generated scripts to include the logic, it would be nice to have an option to inclu...