Red Gate forums: SQL Comparison SDK 10

RE: Get List of Dependencies

sebling — Wed, 22 May 2013 17:58:19 GMT

Never mind - found it in Migrations VersionedWork

Get List of Dependencies

sebling — Wed, 22 May 2013 17:53:36 GMT

WIKI shows using Work.ProcessDifferences but no such method exists in SDK 10

RE: SQL Compare SDK removing users from database

chris.brown — Tue, 21 May 2013 15:08:22 GMT

The solution to this issue is to loop through the objects in the database, ensure you set all the users .Selected = false then the SQL compare will completely ignore them.

SQL Compare SDK removing users from database

chris.brown — Mon, 20 May 2013 14:02:37 GMT

When I compare my database with a database creation script created from a VS 2010 data-tier application project, the users are removed my database.

In the dta project, I have defined a database role, but there are no users as these are created within the installer in which SQL Compare SDK is implemented.

In my code I have set the options IgnoreUsers and IgnoreUserProperties but I can't stop the users being removed.

Has anyone come across this problem and/or know any solution?

Thanks.

Force updates rather than inserts

dinonz — Fri, 17 May 2013 14:33:02 GMT

Hi,

I'm trying to do a comparison every 15 minutes and keep a target database up to date. I have fields whereby I can filter what has been added, and what has been changed in the last 15 minutes.

Problem is, adding that filter makes it want to "insert" all records that have changed, because they don't appear to be in the target data because they have not changed there. Is there a way to force the generation of SQL to always make update statement not inserts?

Dino

RE: Generate Comparison Results Report

clamk123 — Thu, 16 May 2013 20:11:03 GMT

Never mind. I found a line in the SDK help that says it's not supported since its a UI function only.

There are some code samples in the wiki that shows a brute force method for emulating it, I'll just work with that.

Generate Comparison Results Report

clamk123 — Thu, 16 May 2013 19:28:25 GMT

One of the thngs we do with SQL Compare is generate the "Generate Comparison Results Report" under Tools in the menu.

What I'd like to do is do this same things through the API, however I'm having difficulty finding where and how to accomplish that via code.

The result I'm trying to accomplish is to do exactly what would happen through the UI if I compared two databases, went to Tools>Generate Comparison Results Report, and chose to output a file as Format: XML.

Is this something than can be done, and if so, can you point me to some documentation/code sample/class names to accomplish this?

RE: Compare Database throws NullReferenceException

Brian Donahue — Wed, 08 May 2013 14:40:01 GMT

I can decode the stack frames at my end and the method names do point towards a problem with collations.

If you don't have any joy, I'll email you a link to our debugging tool and that may help.

RE: Compare Database throws NullReferenceException

MarkLFT — Mon, 06 May 2013 14:29:03 GMT

Hi,

We are not comparing to scripts, we are comparing a database tables with another database tables.

In the command CompareDatabases() there are only three parameters, db1, db2, and mapping. I have checked these and the are not null, I also checked the properties of these three objects, and none of the properties are null.

With regards to going further into the stack trace, as you can see, all the methods have been obfuscated. I am guess by you guys.

I will check the collation settings, but I am sure they are the same on both servers.

Thanks

RE: Compare Database throws NullReferenceException

Brian Donahue — Mon, 06 May 2013 14:19:59 GMT

Hello,

It's hard to say from the stack trace, but it looks like something to do with collations or not knowing what the collation of the database is. Depends on if you are comparing scripts, or scripts to live databases, or something in the code. Scripts folders should have the table schema and the RedGateDatabaseInfo.xml file which should set the collation.

Or you could bypass the whole issue and use the option to do a binary comparison, but then it compares text case-sensitively and including white space and you may not want that.

Like with all null-ref exceptions, you want to debug and look at the local variables to see if anything is set to null and if those variables are being used. So the stack trace is part of the troubleshooting but I can't draw any definitive conclusions from it.

Compare Database throws NullReferenceException

MarkLFT — Sat, 04 May 2013 06:56:55 GMT

I have a Windows Service application, that runs continuously. The app will check for differences between two databases, and the syncs the changes from DB2 to Db1.

We use the DataCompare SDK to do this.

The service will run for days, sometimes weeks with no problem. But then without warning, it will throw a NullReferenceException on the command

session.CompareDatabases(db1, db2, mappings);

If I restart the service it will sometimes go away, sometimes it will come back immediately. Other times the problem will fix it self after a couple of hours. But then reoccur a few hours later.

The job runs every few minutes, and is identical in its settings for every run. So I find it confusing that we would get these errors so intermittently.

Can you please offer any advice, on how I can pint down the route cause.

To help I have attached a Stack trace from one of the errors.

Code:

#8ZK.#7ZK #pmc(String #A2Tb, String #K12b, String #aLPb, Boolean #NMrc):330
#8ZK.#pmc #89K(String #1Z, String #y0, FieldPair #M9rc, Boolean #N9rc):97
#8ZK.#pmc #89K(IComparable #WfVb, IComparable #H12b, FieldPair #M9rc, Boolean #N9rc, Boolean #O9rc):397
RedGate.SQLDataCompare.Engine.ResultsStore.Store IdenticalValues(Object value1, Object value2, FieldPair fieldPair, Boolean forceBinaryString, Boolean roundDoubles, Boolean treatEmptyStringAsNull):434
RedGate.SQLDataCompare.Engine.ComparisonSession #paL(Int32 #39rc, Object[] #09rc, Object[] #19rc, IList`1 #49rc, DifferencesSummary #59rc, Byte[] #29rc, Boolean #N9rc, Boolean #O9rc, Boolean #69rc):17
RedGate.SQLDataCompare.Engine.ComparisonSession #maL(#H1K #X9rc, #H1K #Y9rc, TableMapping #3Krc, ProgressPercentageTracker #luPb):0
RedGate.SQLDataCompare.Engine.ComparisonSession CompareDatabases(Database db1, Database db2, TableMappings mappings, SessionSettings sessionSettings, Boolean doNotBeDefeated):1570
RedGate.SQLDataCompare.Engine.ComparisonSession CompareDatabases(Database db1, Database db2, TableMappings mappings, SessionSettings sessionSettings):0
RedGate.SQLDataCompare.Engine.ComparisonSession CompareDatabases(Database db1, Database db2, TableMappings mappings):0
D:\_My Projects\Resort Manager\Dev\ResortManager\Utility Apps\RedGateWrapper\RedGateWrapper\SQLDataCompare.cs:190 in `SynchronizeData(IList`1 tableNames, SelectionDelegateType delegateType, TableMappingsType mappingsType, MappingOptions mappingOptions, Boolean applyWhereClause)`

[/code]

RE: Ignore Dependancies

james.billings — Wed, 01 May 2013 14:01:53 GMT

Hi-

Presumably in your code you've specified the options you want to use, with the Options enumeration. Quite possibly with "Options.Default".

Including dependencies is one of the default options (detailed here) so to turn it "off" you need to replace your various Options settings:

Code:

Options.default

with

Code:

Hope that helps.

Ignore Dependancies

MatthewB — Tue, 30 Apr 2013 08:37:48 GMT

How do ignore dependencies when you BuildFromDifferences?

RE: How to inject additional SQL Code into script

Brian Donahue — Thu, 25 Apr 2013 09:16:25 GMT

Hello Myles, SDK doesn't specifically support slipstreaming SQL into the code written by the ExecutionBlock. What I do is pull apart the individual blocks and write them out in a loop -- then I can put my own custom SQL wherever I need to. Please see code sample here:

http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Comparison_SDK/KB200809000297

How to inject additional SQL Code into script

mylesp — Wed, 24 Apr 2013 00:06:55 GMT

As part of the differences/upgrade script produced, at the end and within the same transaction we want to be able to call stored procedures and update data tables (e.g. update the internal records that contain our database schema version).

Of course we want this to happen as part of the same transaction.

Is this possible?

We currently use the SQL Compare tool and then modify the script to perform these actions, but of course this cannot be done if we automate this process.

Or is there some way to wrap the current code up so that it uses an external transaction, and we can then perform the actions using normal ADO.NET functionality.

Thanks,
Myles.