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.