Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
RE: How can I transfer data from SapDB 7.4 to maxDB 7.5
Date: Tue Jul 06 2004 - 06:58:12 CDT
if you look at my first thread, you'll see that I tried to use the loader.
Below you can see what I've tried.
I try to export a user data from SapDB 7.4 and import the data to maxDB 7.5.
For the export I used the loadercli 7.4 command
TABLEEXTRACT USER DATA OUTSTREAM FILE 'user.data'
If I try to load the file using loadcli 7.4, I get the error message "kernel versions differ".
If I using loadcli 7.5, get the error message "Error processing TABLELOAD; Loader versions used for TABLEEXTRACT and TABLELOAD differ (TABLEEXTRACT: 7.4.03, TABLELOAD: 7.5.00)".
How can I do it ?
Can I replicate a user directly from my old database 7.4 to my new one 7.5, without writing to a file ?
I've read in the documentation, that the TABLELOAD will change or create the necessary catalog information.
Is there a way to load only the data of an export file?
>backups contain indeed the complete database, as they were invented for disaster recovery.
>So you can A) transfer the complete database using a backup and throw away the unwanted
>data, or you can B) use MaxDB's loader ( http://dev.mysql.com/doc/maxdb/en/2d/c6c63522b8057ce10000009b38f889/frameset.htm <http://dev.mysql.com/doc/maxdb/en/2d/c6c63522b8057ce10000009b38f889/frameset.htm> ")
>to unload and load the data you are interested in.
>SAP Labs Berlin
>From: Andre.Sudhofft-systems.com <mailto:Andre.Sudhofft-systems.com>
>Sent: Thursday, July 01, 2004 5:16 PM
>To: maxdblists.mysql.com <mailto:maxdblists.mysql.com>
>Subject: RE: How can I transfer data from SapDB 7.4 to maxDB 7.5
>I've tried to recover from a backup. It works, but not the way I want.
>You can recover the whole instance and not a user only.
>Or did I something wrong ???