moving databases and SPL
Looking for some information on how to move databases along with stored
procedures from machine to machine. (Identical setup on these two
machines - just going to a production environment from development.) I
typically use dbexport to do this with - but oops- no stored
procedures. Anybody have any experience doing this?
--
----------------------------------------------------------------
Maria L. Wilson 757.766.8265 757.766.2571(fax)
Computer Sciences Corporation
NASA Langley Research Center m.l.wilson@larc.nasa.gov
Hampton, VA 23666 http://www.larc.nasa.gov
----------------------------------------------------------------
Hmmmmmmm . . . I thought that dbexport would include all SPL.
Anyway, if you have an identical setup between boxes, why not restore
your production data to your test box using ontape. We've been doing
that for a few years now with no problems.
John Carlson
Informix DBA
WHSmith USA
Maria Wilson wrote:
>
> Looking for some information on how to move databases along with stored
> procedures from machine to machine. (Identical setup on these two
> machines - just going to a production environment from development.) I
> typically use dbexport to do this with - but oops- no stored
> procedures. Anybody have any experience doing this?
>
> --
> ----------------------------------------------------------------
> Maria L. Wilson 757.766.8265 757.766.2571(fax)
> Computer Sciences Corporation
> NASA Langley Research Center m.l.wilson@larc.nasa.gov
> Hampton, VA 23666 http://www.larc.nasa.gov
> ----------------------------------------------------------------
In article <7ac21v$mkq$1@news.xmission.com>,
Maria Wilson <m.l.wilson@larc.nasa.gov> wrote:
>
> Looking for some information on how to move databases along with stored
> procedures from machine to machine. (Identical setup on these two
> machines - just going to a production environment from development.) I
> typically use dbexport to do this with - but oops- no stored
> procedures. Anybody have any experience doing this?
Are you sure your *.sql file created by dbexport does not contain stored
procedures? Are you using the -ss option (not sure if this is the key).
If dbexport won't work for you and your servers are really identical, you
could take a level 0 archive on the first machine and restore it on the 2nd
machine using ontape. If you are running the same Informix version and the
same OS version on each server, you could also use onunload/onload to move
the database only.
Good luck,
Bob
-----------
>
> --
> ----------------------------------------------------------------
> Maria L. Wilson 757.766.8265 757.766.2571(fax)
> Computer Sciences Corporation
> NASA Langley Research Center m.l.wilson@larc.nasa.gov
> Hampton, VA 23666 http://www.larc.nasa.gov
> ----------------------------------------------------------------
>
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own