UniDAC vs SQL SDAC

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MatjazCof
Posts: 1
Joined: Sun 11 Dec 2016 09:27

UniDAC vs SQL SDAC

Post by MatjazCof » Sun 11 Dec 2016 09:43

Can someone please clarify what is the difference between SQL Server Data Access Components and Universal Data Access Components.
The price confused me. It is the same, but UniDAC can connect to multiple database where SQL SDAC can connect only to MsSQL server. But the price are the same for both products.
I expect UniDAC would cost more.


Professional Edition with source code
UniDAC Professional Edition + Source Access*
$449.95 $1099.95 $1999.95
vs
Professional Edition with source code
SDAC Professional Edition + Source Access*
$449.95 $1099.95 $1999.95

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: UniDAC vs SQL SDAC

Post by azyk » Wed 14 Dec 2016 09:33

UniDAC allows working with a large number of databases, but it has limited functionality to work with each of them. SDAC allows working only with one database, but it operates with a richer functionality set. In order to balance their functionality/cost ratio, the prices were made the same.

unidac5src
Posts: 8
Joined: Wed 22 Apr 2015 07:33

Re: UniDAC vs SQL SDAC

Post by unidac5src » Wed 14 Dec 2016 09:41

Thank you.
Do you have compare table which would help me determine what are additional functionalities in SDAC?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: UniDAC vs SQL SDAC

Post by azyk » Wed 14 Dec 2016 10:52

To access SQL Server, UniDAC uses the same main modules that are used in SDAC. However, UniDAC has no support for some specific SQL Server features, that are supported in SDAC:

- ServiceBroker;
- ChangeNotification;
- the NonBlocking mode, in which an SQL query is executed in a separate thread;
- data types: geometry, geography, hierarchyid, and xml

Therefore, if you don't plan to use SDAC specific features, there is no difference between using SDAC and UniDAC.

Also you can check the feature differences following these links:
https://www.devart.com/unidac/components.html and https://www.devart.com/sdac/components.html

Post Reply