Subject Re: [firebird-support] Re: Re: Connecting to another database from within a stored procedure (was "Upgrading a database")
Author Carl Peto
I'm not sure how to connect to another database from within a database in

It's a trick I was very familiar with in Oracle but have never learned how
to do in Firebird. I'd be interested to find out.

----- Original Message -----
From: "Anand" <akashelkar@...>
To: <>
Sent: Wednesday, March 31, 2004 8:20 AM
Subject: [firebird-support] Re: Re: Upgrading a database

> Thanks both Alexandre and Carl :) Fortunately we don't have any
> triggers,
> and the views don't use any SPs, so that's a few dependencies
> less :) Since
> the previous design was not properly normalized, we had to
> revamp it almost
> completely, so dependency-wise it's not too complicated right
> now. However
> since this design will remain stable now, with only a few
> additions as per
> feature requirements, we shall soon look towards adding triggers
> and
> introducing more constraints in the near future. Your advice
> will surely be
> useful at that time.
> Yes, I have documented the table design, but not the SPs and
> Views. It's
> easy but time-consuming, and as always, we are short of time :(
> I am using
> a freeware tool IBExpert (Personal Edition) and it does show the
> dependencies of an object as also the metadata, so that's not a
> problem for
> me.
> What I would like to know more if I were to create a separate
> database
> containing the new structure, say DBNew, and I wanted to use a
> few SPs to
> copy data from the old database, say DBOld, into the DBNew,
> would it be
> possible and how? Then I could create the new structure in a
> separate GDB
> file, copy all the old data, and then simply delete the old GDB
> file and
> rename the new one. I just am not sure if I can do this easily
> from within
> SPs written in DBNew, or would I need to use my application to
> perform the
> data transfer.
> Anand
> 21. Re: Upgrading a database
> From: Alexandre Benson Smith
> <iblist@...>
> 23. Re: Upgrading a database
> From: "Carl Peto" <carl@...>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> --------------------------------------------------------------------------
> Yahoo! Groups Links
> a.. To visit your group on the web, go to:
> b.. To unsubscribe from this group, send an email to:
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.