Re: migrating databases
Posted in 2000
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
From: "John Visicaro" <jvisicaro@stl-inc.com>
>
>I am going to migrate my database from one Sun server to another. I would
>like to transfer the existing structure from datafiles to chunks. How do I
>set it up? Are there any rules or guidelines to follow when specifying
>which
>tables go into which chunks? More imporantly how do I do it? Would I use
>onmonitor, dbaccess or the Sun?
Set up your chunks on box B. dbexport -ss from box A. Edit the generated SQL
to place things in the desired chunks. dbimport on box B.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com