On Tuesday, 20 August 2019 at 11:33:33 UTC, Anders S wrote:
I'm creating an application that connect to a database and write data from another application. Now when I start the application I want it to check if the database exists and if not create the database and it's tables.

I have everything working IF the database and tables exist.

Use this code to check
conn.exec("CREATE DATABASE IF NOT EXISTS boxweb;");

however haven't found a way to run the sql file that create the tables. The file is in the source folder

Any ideas ?

You need to use an additional library to communicate with the database. The library to use depends on the type of database (Oracle, DB2, sqlite, Hana, postgres,...)

Which database type do you target?

Kind regards
Andre

Reply via email to