Devart Forums

I am trying to figure out a method of distributing updates to my endusers database and think I have to look at the unified SQL in UniDAC to get it working. But I miss some samples on how it works/can be made.

Or if there is a much better way of doing the job please let me know.

Please describe in more details what you mean by distributing updates.

You can find the description of Unified SQL in the UniDAC help (Using UniDAC / Unified SQL).

Distributing updates:

Customer have version 1.0.0 of application and db
I develop version 1.1.1 which uses 4 new fields and a new table in the db.
In order for customer to use the new 1.1.1 version his db needs to be upgraded and it is theese updates/upgrades I need to distribute with the new application so that customer can run an update the fixes his db.

You can use Unified SQL to write an update script, if this script has some differences for different DBMS.

That was my plan - I just need some 'reallife' samples to look at

oz8hp wrote:That was my plan - I just need some 'reallife' samples to look at

with UniQueryUpdate do begin
SQL.Clear;
SQL.Add( ' {if Oracle} ' );
SQL.Add( ' alter table dept add xxxxxxx ' );
SQL.Add( ' {else} ' );
SQL.Add( ' alter table test.dept add xxxxxxx ' );
SQL.Add( ' {endif} ' );
Execute
end;

Unidac will be execute the statment accordint with provider.

Unified SQL tecnology is a Big feature of Unidac.. good Devart!!