Subject | Re: [firebird-support] Copying databases |
---|---|
Author | Olivier Mascia |
Post date | 2004-12-01T18:02:48Z |
On Wed, 01 Dec 2004 17:58:52 -0000,
"yaedos2000" <yaedos2000@...> wrote:
y> 1. When creating a new datbase from an original one (without the data
y> being carried over), how do you copy the procedures, triggers and
y> views as well?
backup with gbak -m (metadata only)
then restore
y> 2. Do tables and procedures have to be stored in the same database
y> file, or can you one database for the procedures (central database)
y> and other databases for the tables on the same server?
No. Procedures, triggers and the like belong to each database. You have
to have them in all databases. Firebird is database-centric, not
server-centric.
--
Olivier Mascia
"yaedos2000" <yaedos2000@...> wrote:
y> 1. When creating a new datbase from an original one (without the data
y> being carried over), how do you copy the procedures, triggers and
y> views as well?
backup with gbak -m (metadata only)
then restore
y> 2. Do tables and procedures have to be stored in the same database
y> file, or can you one database for the procedures (central database)
y> and other databases for the tables on the same server?
No. Procedures, triggers and the like belong to each database. You have
to have them in all databases. Firebird is database-centric, not
server-centric.
--
Olivier Mascia