[fpc-devel] SqlDB's TSQLScript backport request

[Graeme Geldenhuys]

On Wed, Nov 12, 2008 at 10:46 AM, Michael Van Canneyt
<michael at freepascal.org> wrote:
>> BTW: That component is a lifesaver! It makes setup and configuration
>> of database applications a breeze. :-)
>
> I know, that's what I use it for.
> I developed it years ago. It's been in use for almost 10 years now.
> The only thing that was done is make it SQLDB-aware.
>
> Currently it works as follows:
> - Create Data dictionary with DB desktop.
> - The FCL-DB Codegen units are used to create a unit that recreates the
>  data dictionary in memory.
> - When a new database is needed, another fcl-db codegen unit cretes the
>  script.

We don't use Laz Data Desktop for this yet. We currently use a tool
called DB Dezign. It allows visual database design and generates the
Create and Drop scripts for any of the supported DB backends. The
scripts it generates is very neat. An awesome tool!

> - TSQLScript is run with this script to create the database.

Yup. I've always had issues trying to use bash script and isql to
create a blank database. TSQLScript makes this all childs play.


Regards,
  - Graeme -


_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/