Read Me

dbupdater
===============

This directory contains the database tool dbupdater.
This is a small tool useful to update a database using a folder with sql script inside.

To keep track of updates, a system table named XSB_UPDATES will be created. 
This table will be updated automatically after the execution of each script sql.
The only restriction is that each script must begin with a series of 6 numerical digits followed by an optional description, for example: 
000001_CREATE_TABLE.SQL

Developer with lazarus on linux x64 but it should run on any platform.

Current supported databases:
- Firebird
- Sqlite 3
- MsSql server

To use:
1) build and run dbupdaterxs
2) select a projects root folder
3) select a project name
4) configure a database connection
5) click update

Your database will be populated by "employee" database (see script in subfolder "employee").


Credits:
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial0
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial1
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial2
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial3
lazarus/examples/database/tsqlscript/

Please see that article for instructions and requirements.
(You'll need database clients and a sample database; see the article)