[Firebird-net-provider] How can I create script from schema?

I have an modular application, each module use a prefix, SYS for system, INV for inventory, etc.

I have created upsize application to create database from script file and pump data from ‘old’ database.

Now I want to create a extract application, which create scripts from development database.

I could get domains, tables, etc,etc…using FbConnection.GetSchema but how can I generate script files for that????

For example, for domain I want to export schema like:

CREATE DOMAIN DAYTYPE AS

CHAR(1)

NOT NULL

CHECK (VALUE IN ('D', 'S', 'C', 'F', 'T'));

There is other possibilities without other tools???

TIA

PaulM

Reply via email to