-----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, [EMAIL PROTECTED] **
** 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
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
