Hi Dmitry
On 28 July 2014 14:39, Dmitry Yemanov <firebi...@yandex.ru> wrote:
>
> Yes, it's actively developed. No, it doesn't support schemas. I don't
> think you can have/use schemas without recompiling all those thousands
> of existing applications and/or their underlying database connectivity
> libraries.
>
>
That is not exactly true. With Schema's, on DB2 and Oracle at least, not
sure about other platforms, you can specify a default schema, either
publicly or by user/connection.
You also have a sql object called a synonym. It acts as the database
equivalent to a soft link. You can even link a remote database as a
schema if you really wanted to get fancy.
For legacy databases, you have a schema called legacy which is the default
schema - you do not need to specify a schema path if you are referencing
anything in your default schema. You make synonyms for all the system
tables in the legacy schema. A pre-schema database would restore into
the legacy schema while legacy apps would all use the default schema.
There would be no difference for them.
New applications could stay with the legacy or go with the newer name space
schema approach.
If a schema within a schema structure was used, you would make it easier to
migrate databases from other platforms onto firebird.
regards
Dalton
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
