Red Gate forums :: View topic - SQL SDK 8
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

SQL SDK 8

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
conquistadorst



Joined: 28 Aug 2009
Posts: 7

PostPosted: Fri Jan 03, 2014 10:25 pm    Post subject: SQL SDK 8 Reply with quote

Looking for a little guidance before I spend another 16 hours trying to make sense of this.

Is SQL SDK8 incompatible with SQL 2012? We've recently upgraded our SQL Server from 2008 R2 to 2012 and suddenly the SDK seems to have stopped working, only providing an unintelligible error on a final Dispose method coming from Redgate.Shared.Utils. I thought OK, "let's try swapping out the SDK with version 10 and see if that fixes it". Which brings me now to my 2nd issue where it doesn't work with VB.net on .net 3.5 or newer!?! (source: http://www.red-gate.com/messageboard/viewtopic.php?t=15329) And spits an even less helpful error than the first. I tried converting the single project in the solution to C# but I'm afraid the single project out of the solution isn't enough because the error is still there.

What is my best option here?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 06, 2014 1:55 pm    Post subject: Reply with quote

Thanks for your post,

Yes, we didn't support SQL 2012 until v10 of the tool.

The .net 3.5 is also resolved in the latest version.

Hopefully upgrading should get you back up and running, but let us know if have have another other issues.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
conquistadorst



Joined: 28 Aug 2009
Posts: 7

PostPosted: Mon Jan 06, 2014 3:37 pm    Post subject: Re: Reply with quote

Chris Auckland wrote:
Thanks for your post,

Yes, we didn't support SQL 2012 until v10 of the tool.

The .net 3.5 is also resolved in the latest version.

Hopefully upgrading should get you back up and running, but let us know if have have another other issues.


I'm already trying SDK 10 in VB.net and it produces the compilation error at runtime I referenced in my original post:

BC30560: 'ExtensionAttribute' is ambiguous in the namespace 'System.Runtime.CompilerServices'.

I reproduced this error in a new simple blank VB.net web app project with the same result. The project will not run and compile in .net 3.5 or newer. I also determined that not only do you have to downgrade any projects using the SDK, but any project referencing a project that uses the SDK i.e. downgrade the entire solution to .net 2.0 which is impossible for nearly all practical situations. The issue doesn't seem to be resolved in SDK 10, is there a newer version than that available somewhere?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 13, 2014 3:44 pm    Post subject: Reply with quote

Sorry for the delay, I didn't notice your last reply.

Could you try the following build:
ftp://support.red-gate.com/patches/SQLComparisonSDK/23Jan2013/SQL%20Comparison%20SDK_10.0.0.265_AnyCPU_r225463.exe
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
conquistadorst



Joined: 28 Aug 2009
Posts: 7

PostPosted: Tue Jan 14, 2014 2:17 pm    Post subject: Re: Reply with quote

Chris Auckland wrote:
Sorry for the delay, I didn't notice your last reply.

Could you try the following build:
ftp://support.red-gate.com/patches/SQLComparisonSDK/23Jan2013/SQL%20Comparison%20SDK_10.0.0.265_AnyCPU_r225463.exe


Yes! Finally it works! I did some preliminary tests and everything seems to be checking out OK. Which is a big relief because the last option we were pursuing here was bringing up a separate SQL Box to stay on 2008 R2 for just a single app but would have cascaded many, many changes to other apps.

There did seem to be one minor notable change since the last release though. The bitwise previous operators to combine options seemed to have changed from using simple "Or" statements to a "Plus" function you guys are now including.

It changed from:
Code:
Dim differences As Differences = DB1.CompareWith(DB2, Options.Default Or Options.IgnoreTriggers Or Options.IgnoreIndexes)

to:
Code:
Dim differences As Differences = DB1.CompareWith(DB2, Options.Default.Plus(Options.IgnoreTriggers).Plus(Options.IgnoreIndexes))
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Jan 14, 2014 4:05 pm    Post subject: Reply with quote

That's great, thanks for letting me know.

The options in the previous version used to be an enum, now they're a type, which is why you need to use the plus() method rather than the bitwise OR to combine the options.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group