Re: Migration problem

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/02/03
Message-ID: <mjrE51B9C.GEK@netcom.com>#1/1

In article <32F25693.69D8_at_centers.co.uk>, Mike Hartas <mike.hartas_at_centers.co.uk> wrote:
>In a few weeks I have to migrate a 7.2 database onto a new compter that
>for O/S reasons has to run 7.3 but I cannot do a full export to disk for
>space reasons and am reluctant to export to tape. Can I do a full export
>with rows=n and then build up the database after or will i run into
>problems with systems objects. Any advice or better suggestions would be
>greatly appreciated.
>
>Mike Hartas.
>
>

There are at least 2 ways to do this with almost no disk required.

First use dblinks between the two dbs and just to a

create <table> unrecoverable as
select * from <table in other db>;

for every table.

or

export to a named pipe
compress the data in the pipe
dd the compress data to the 2nd system
uncompress the data into another named pipe on the second system import the data

Hope this helps

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Mon Feb 03 1997 - 00:00:00 CST