[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    Re: Migrate all tables to other db instance
From:       Juergen Sauer <jojo () automatix ! de>
Date:       2002-12-27 14:50:06
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am Freitag, 27. Dezember 2002 12:10 schrieb Marcio Suda:
> Where i can find resources/docs to migrate all data from one database
> instance to other instance. repmcli only exports a single table at time, is
> there any way to export all tables from a database ?

Yes, of course.
There is a fine referecne in the doc pages in the net.
Look for 'Replication Manager' or repmcli.

The repmcli is not an interactive tool. You need to create a short
Scritpt to do the job.

1. create the script like this:
- --- copy all out to file: copy_out.sql ---
TABLEEXTRACT ALL  OUTFILE '/tmp/outfile.unl.'
- ----------------------------------
Run this script like:
repmcli -E 1 -d YOUR_SRC_INSTANCE -u YOUR_SYSDBA,PASSWORD -b copy_out.sql
- -----------------------------------
Copy both files to the destination server:
scp -C /tmp/outfile.unl.* dest_server:/tmp
Coping the Dump file may be obsolete, if you use the replication manager 
Server.

For Re-Import you need a fresh, maiden Database Instance
you need a copy in script copy_in.sql:
- ---------------------------
TABLELOAD ALL INFILE '/tmp/outfile.unl.' OUTFILE '/tmp/restart.dat'
//
- ---------- 
repmcli -E 1 -d YOUR_DEST_INSTANCE -u YOUR_SYSDBA,PASSWORD -b copy_in.sql

BTW: You can also use the repmcli for executing SQL Scripts.
Use "//" as separator like already known from SQL Studio.
mfG
	J. Sauer
- -- 
Jürgen Sauer - AutomatiX GmbH, +49-4209-4699, jojo@automatix.de **
** Das Linux Systemhaus - Service - Support - Server - Lösungen **
** http://www.automatix.de http://www.kranautomatisierung.de    **
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+DGieW7UKI9EqarERArevAKDTa02Gokai3fHQeQhvzXr0XIX3ZQCgmBGN
BenznAb2qmilrLm1nSA+6No=
=3CiH
-----END PGP SIGNATURE-----

_______________________________________________
sapdb.general mailing list
sapdb.general@listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
[prev in list] [next in list] [prev in thread] [next in thread]