TMS Aurelius / TMS Data Modeler and PostgreSQL and UniDAC

[wlandgraf (Wagner Landgraf)]

PostgreSQL is fully supported, but you have to indicate the sequences for the tables when importing classes from existing database, like you said you did in the Export-Settings.

In the TMS Aurelius connection popup you can simply tell the importer to ignore the sequences, import the tables, and then add the sequences later in the mapping, if needed.

This was discussed in this topic:

EMissingSequenceError problem

Hi Paul, You've hit a very specific situation.First, when the database doesn't support identity/autogenerated columns, Aurelius will require sequences/generators to be associated with each table for id generation. That means that for SQL Server, for example, nothing will happen, but for Firebird 2.5 for example, a generator for a table with an autogenerated id is required. That's why the entity generator asks you that. You can control that in option "Check for missing sequences", in tab "Advance…

Regarding UniDAC, design-time support is not installed by default because it's not a native Delphi component, so not available for everyone. You can install it manually, and it's also discussed here:

Aurelius connection to MySQL via uniDAC at designtime?

To create package, use the Delphi menu File | New | Package: [image] Delphi will create a package, right click Contains folder and choose Add...: [image] Find and choose the Aurelius.Drivers.UniDac.pas file: [image] Then right-click the package name and click Install. You can save the package somewhere in your disk for later usage and recompilation. [image] About Data Modeler, indeed you have to use a x86 version of libmysql.dll file. You can use 5.7 version and the same for MS SQL, y…