Devart Forums

Using Unidac I'm curious if there's any way to create a MySql, Oracle and SqLite database.

So if I have Oracle installed can I create a new DB with all the default shemas, tables and data rows present?

Same question for MySql if I have MySql server installer.

And again for SqLite if I have the .dll in hand.

For all 3 of the above, if it's possible can someone point me in the direction of or prvide DELPHI code examples of how to accomplish it?

Thanks in advance for any help.


drc

I prefer to create users and databases manually (empty). For PostgreSQL (Oracle in you case) also schema.
All other things with SQL commands from my app.

Only one exception regarding SQLite where I prefer to check connection option ForceCreateDatabase

Best regards,
Cristian Peta

Hello,

SQLite is a file database, therefore the database will be created on the first connection (the ForceCreateDatabase option must be set). In Oracle and PostgreSQL a database or a schema can be created with SQL commands. More details can be found in documentation of particular servers.