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.
SDAC vrs UniDac
Re: SDAC vrs UniDac
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
- 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
Re: SDAC vrs UniDac
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.
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.