Move Database from one Server to another

Simon Spielmann <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
Hi,

I'm trying to move a database from one server to another, so I died 
something like writen in the migration how to.
First I execute the script:

SET MAXERRORCOUNT 1
//
USE USER dba_user dba_pass SERVERDB comtecdb ON localhost
//
DBEXTRACT CATALOG OUTSTREAM FILE 'c:\db\comtec.cat' DATA OUTSTREAM FILE 
c:\db\comtec.data'
//


with the command

repmcli.exe -u SYSDBA,<passwd> -d <dbname> -n <host> -E 1 -b <script>

this ran without any erros.

Then for import I used the script:

SET MAXERRORCOUNT 1
//
USE USER dba_user dba_pass SERVERDB tst2 ON 130.83.197.34
//
DBLOAD CATALOG INSTREAM FILE 'c:\db\comtec.cat' DATA INSTREAM FILE 
'c:\db\comtec.data0001'

Again without errors.

In the Database are several tables owned by comtecdba.
When I look at the new database with SQL Tool I can the the users from 
the old location but no tables.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.