dbExpress driver for MSSQL with Active Directory Authentication.
Customers want to connect to Azure MSSQL database. Only AD Authentication is allowed.
Maybe same idea as https://devart.uservoice.com/forums/104635-delphi-data-access-components/suggestions/34764841-implementation-of-the-new-authenticatthod-of-newer, but for dbExpress SQL Server driver.17 votes
Add ability to editing some dataset's parameters simultaneously with multiselection in SDAC parameter editor16 votes
I would like to see SDAC implementation of next methods to SQL Server Compact database connection:
Same as is in C# SqlCeEngine class.
Unidac connectionstring add parameter column encryption setting=enabled12 votes
I can make TVirtualTable.Assign( TMSQuery ), but xml and other blob fields are lost. A great pity!9 votes
An optimized version of this (maybe without the need to go to/from dataset to make it go faster)
query := db.CreateMSQuery( ); //returns TMSQuery
query.SQL.Text := 'select * from [table]';
result := binary.create;
VirtualTable := TVirtualTable.Create(nil);
VirtualTable.saveToStream( result );
Please include the scheme name of the stored procedure because now you have to include it manually, and if you dont it throws an error can find stored procedure, if i run MyStoredProcedure it throws an error but if i change it to MyScheme.MyStoredProcedure manually it works.3 votes
Passing parameters by name is more reliable than by index, aspecially when stored procedures is not constant and parameter's list is changed frequently.3 votes
Encryption parameters in SDAC Data
It would be very very usefull to use Parameters on Insert and Update Queries3 votes
In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.
Or can I download the source code for dbMonitor and edit it myself?
The TMSTableData Component Assign function only copy the source table fields, but not copy the source data! I strongly recommend that can copy the all data like the TMSTable component.
The MSTableData1 not copy the MSTable1 data , but it copy the fields2 votes
When TMSConnection.Authentication is auWindows the username is the currently logged in user, it woudl be good to have a way to connect as another user. There could be a new property TMSConnection.ImpersonateUser, if this is set and auWindows is set the connection will be done as if that user is logged in.2 votes
When you have a query like
where COALESCE(DVALIDFROM, :PeriodTo) <= :PeriodTo
Then the params property of a TMSQuery component now contains the parameter 'PeriodTo' twice. This behaviour differs from the behaviour of TUniQuery. I think the behaviour of TMSQuery needs to be changed such that is has the behaviour of TUniQuery.2 votes
ADD new function to export the XML from your table
components in a format compliant with the XSD schema
instead of the XDR format you're using now1 vote
SQL Server now has a new security feature called "Always Encrypted". This is a recognised Microsoft solution for encrypting certain sensitive database columns to meet European Union GDPR regulations. Please add "Always Encrypted" support into Devart SQL Server data access components. This is a recognised approved solution to SQL Server DBA's.1 vote
Add ability TMSDump to dump all of database (not only data) to sql script. i.e schema - create statement, sp,triggers, etc.
The same functionality which has dbforge studio or ssms.1 vote
- Don't see your idea?