User profile for crancoder

I was including the option Options.IncludeDependencies. Removing this solved the problem. / comments

I was including the option Options.IncludeDependencies. Removing this solved the problem.

0 votes

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 ...

1 follower 1 comment 0 votes

Thanks, Michelle. I had some old code with NoSQLPlumbing included in the Options. You are correct, I'd been using the wrong Options object in both CompareWith and Work.BuildFromDifferences / comments

Thanks, Michelle. I had some old code with NoSQLPlumbing included in the Options. You are correct, I'd been using the wrong Options object in both CompareWith and Work.BuildFromDifferences

0 votes

Sorry, I copied off the wrong script in the example given of extendedProperties: Options o = Options.Default | Options.IgnoreExtendedProperties; sourceDB.Register(new ConnectionProperties(textBoxServer.Text, textBoxDatabase.Text, textBoxUsername.Text, textBoxPassword.Text), o); targetDB.Register(new ConnectionProperties(textBoxTargetServer.Text, textBoxTargetDatabase.Text, textBoxTargetUserName.Text, textBoxTargetPassword.Text), o); / comments

Sorry, I copied off the wrong script in the example given of extendedProperties: Options o = Options.Default | Options.IgnoreExtendedProperties; sourceDB.Register(new ConnectionProperties(textBoxSe...

0 votes

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...

2 followers 3 comments 0 votes

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...

1 follower 1 comment 0 votes

Richard, Thanks. / comments

Richard, Thanks.

0 votes

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.

2 followers 2 comments 0 votes

Database Driver

Does SQLCompare (or any of the Red Gate tools for that matter) use native SQL Server drivers or ODBC drivers? Thank you.

1 follower 1 comment 0 votes

Brian - Thanks! / comments

Brian - Thanks!