Red Gate forums: SQL Comparison SDK 10

Failed to compare two elements in the array

JoshNoe — Tue, 11 Jun 2013 22:09:05 GMT

We recently updated the RedGate Compare SDK dlls, and now our previously working app is throwing an error when we call RedGate.SQLCompare.Engine.Database.LoadFromDisk("mysnapshot.snp")

"Failed to compare two elements in the array"

The version appears to be 9.5.0.597, even though I got the dlls from "SDK 10" which I downloaded eariler today.

Stack trace:
at System.Collections.Generic.ArraySortHelper`1.Sort(T[] keys, Int32 index, Int32 length, IComparer`1 comparer)
at System.Collections.Generic.List`1.Sort(Int32 index, Int32 count, IComparer`1 comparer)
at RedGate.SQLCompare.Engine.Indexes.Sort()
at RedGate.SQLCompare.Engine.Indexes.#gjh()
at RedGate.SQLCompare.Engine.Table.PatchUpAfterDeserialization(Database #RHc)
at RedGate.SQLCompare.Engine.Tables.PatchUpAfterDeserialization(Database #RHc)
at RedGate.SQLCompare.Engine.Database.PatchUpAfterDeserialization(Boolean #pXrc)
at RedGate.SQLCompare.Engine.Database.LoadFromStream(Stream #a0, Database #uwL)
at RedGate.SQLCompare.Engine.Database.LoadFromDisk(String #wqk, Database #uwL)
at RedGate.SQLCompare.Engine.Database.LoadFromDisk(String fileName)
at ReleaseUpdate.Synchronizer.SQLSynchronizer(BackgroundWorker worker, DoWorkEventArgs e) in C:\SPIDev\SPITools\PRIME\AutoUpdate\Synchronizer.vb:line 125

RE: Run out of diskspace in SQL Data compare SDK

Philn — Mon, 03 Jun 2013 21:55:32 GMT

I got it!, I restarted my machine, Doh!, it's work now.
Thanks Brian.

RE: Run out of diskspace in SQL Data compare SDK

Brian Donahue — Thu, 30 May 2013 14:58:11 GMT

If you're setting it in code you probably want to set it in the process, otherwise you have to restart the process to get the variable read in, which won't do you much good.

Code:

Environment.SetEnvironmentVariable("RGTEMP", "d:\\temp", EnvironmentVariableTarget.Process);

RE: Generate Comparison Results Report

sralsto — Wed, 29 May 2013 19:33:56 GMT

Hey there,

Quote:

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'm having trouble finding this. Could you point me in the right direction?

We are building an ASP.NET application and need to see a summary of the synchronization changes before we actually synchronize the data.

Any thoughts?

Thanks,
Stefan

RE: Run out of diskspace in SQL Data compare SDK

Philn — Tue, 28 May 2013 23:58:08 GMT

Hi Brian,
thanks for replying. I tried your suggestion, but it seems doesn't do anything - Not sure what I am missing.
I put Env variable (RGTEMP) in both user variable and System Variable and the api still doesn't recognize it.

RE: Run out of diskspace in SQL Data compare SDK

Brian Donahue — Tue, 28 May 2013 09:31:59 GMT

Hi Phil,
It's not a method explicitly in the API but what you can do is set the "RGTEMP" environment variable value to the name of a folder on a different drive with lots of free disk space. In .NET, you can use the System.Environment object and add the RGTEMP variable to your own process. That should do the trick!

Run out of diskspace in SQL Data compare SDK

Philn — Sat, 25 May 2013 00:02:57 GMT

Hi,
Is there an option to set in the SQL Data Compare API to place the temp files into a different path instead of the C:\ drive?
I am comparing a large databases with many tables and the default temp files are in C drive which I don't have much empty space.
Thanks

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.