SDAC vs UniDAC again :)

leonell · Post by **leonell** » Fri 07 Oct 2011 16:30

Hello,
I add here this "never ending story"

What is clear for me:
UniDAC does not have ServiceBroker
UniDAC does not have ChangeNotification
UniDAC can not work in NonBlocking mode
UniDAC does not have support for geometry and geography types

What next?
Support for connection encryption without certificate validation ? SpecificOptions.ENCRYPT ?
Which SQL SERVER data types are NOT supported in UniDAC (excl geometry and geography)?
Ability to lock records and tables?
Distributed transactions support?
Cursors? SpecificOptions.CURSORUPDATE ?
Some others?

Thank you very much.

AndreyZ · Post by **AndreyZ** » Tue 11 Oct 2011 07:31

Support for connection encryption without certificate validation ? SpecificOptions.ENCRYPT ?

Both UniDAC and SDAC support encryption without validation (the TrustServerCertificate connection option).

Which SQL SERVER data types are NOT supported in UniDAC (excl geometry and geography)?

Except the geography and geometry SQL Server types UniDAC doesn't support hierarchyid and xml types.

Ability to lock records and tables?

UniDAC doesn't support tables locking, but both UniDAC and SDAC support records locking (the LockMode option). Using UniDAC you can lock table by setting your own SQL query in the SQLLock property.

Distributed transactions support?

You can start distributed transactions using both UniDAC and SDAC.

Cursors? SpecificOptions.CURSORUPDATE ?

For the time being UniDAC doesn't support cursors.

Some others?

UniDAC doesn't support working with the FILESTREAM data and with Table-Valued Parameters.

leonell · Post by **leonell** » Tue 11 Oct 2011 16:55

Thank you very much.

And (I hope that last) question:

Please can you describe when you are using cursors in SDAC?
Which operations will be slower in UniDAC against SDAC?

Thanks,
Leos

AndreyZ · Post by **AndreyZ** » Wed 12 Oct 2011 08:59

Different cursors can be used for different data operations. Please read the description of TMSCursorType Enumeration in the SDAC documentation.
UniDAC will not be slower than SDAC, because both SDAC and UniDAC use the DefaultResultSet cursor by default. UniDAC cannot use the Dynamic, Keyset, Static, and BaseTable cursors. With SDAC you can use these cursors. You can learn more about SQL Server cursors here:
http://msdn.microsoft.com/en-us/library/aa172578
http://msdn.microsoft.com/en-us/library/Aa172568
http://msdn.microsoft.com/en-us/library ... l.80).aspx

DiGi · Post by **DiGi** » Fri 24 Feb 2012 14:42

Is it possible to downgrade license from UniDAC to SDAC? We are missing Table-valued params

AndreyZ · Post by **AndreyZ** » Mon 27 Feb 2012 11:11

I have redirected your question to our sales department. They will answer you soon.

Devart · Post by **Devart** » Mon 27 Feb 2012 12:48

DiGi wrote:Is it possible to downgrade license from UniDAC to SDAC? We are missing Table-valued params

It's possible, please send your UniDAC license number to our sales team to process downgrade.

Regards,
Devart Support