SDAC vrs UniDac

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rezasadigh
Posts: 3
Joined: Fri 03 Feb 2017 15:36

SDAC vrs UniDac

Post by rezasadigh » Fri 03 Feb 2017 15:51

I used SDAC previously but now I want to migrate from SDAC to UniDac now I want to Know
1- if Unidac has any disadvantage (kile speed) from SDAC
2- is Migration is easy and safe or not
thanks a lot and apologize for my bad english.

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

Re: SDAC vrs UniDac

Post by azyk » Mon 06 Feb 2017 10:22

1) To access SQL Server, UniDAC uses the same basic modules that are used in SDAC, therefore UniDAC has the same performance in comparison with SDAC. However, UniDAC does not support some specific SQL Server features supported by SDAC:

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

Therefore, if you do not plan to use these specific SDAC features, there is no difference in using SDAC or UniDAC.

2) In SDAC/UniDAC there is a separate utility Migration Wizard, which automatically replaces DB access components in the project or its individual units to the same SDAC/UniDAC components. Migration Wizard also has the ability to do backup before migration and restore from backup.

Learn more about Migration Wizard in
SDAC: https://www.devart.com/sdac/docs/?migration_wizard.htm
UniDAC: https://www.devart.com/unidac/docs/?mig ... wizard.htm

rezasadigh
Posts: 3
Joined: Fri 03 Feb 2017 15:36

Re: SDAC vrs UniDac

Post by rezasadigh » Sat 25 Feb 2017 06:14

thanks a lot azyk

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: SDAC vrs UniDac

Post by ViktorV » Mon 27 Feb 2017 12:08

Thank you for your interest to our product.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply