Posts
Sort by recent activity
Excluding Differences
I am setting Difference.Selected to false before calling BuildFromDifferences for a subgroup of tables and views.
This seems to work for tables, but not for views. In other words, even though I'm ...
Extended Properties, Transactions
I've been working with the SQL Compare API to generate a database synchronization script.
I've included the Options.IgnoreExtendedProperties enumeration*, but "EXEC sp_addextendedproperty" commands...
Parsing Table Differences
I'm trying to build a script which puts conditionals around ALTER TABLE statements.
Example (pseudocode):
IF(target database table A does not have field
BEGIN
ALTER TABLE A add field B....
END
I'd...
Use of Exclude in API?
Does the Data Compare API provide the ability to exclude tables, similar to the command line "exclude" switch?
Thank you.
Database Driver
Does SQLCompare (or any of the Red Gate tools for that matter) use native SQL Server drivers or ODBC drivers?
Thank you.
Force Table Rebuild
Can someone please provide a complete list of the circumstances under which SQL Compare forces a rebuild of a table?
For example, SQL Compare forces a rebuild if the target table has an identity fi...