OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: How can I transfer data from SapDB 7.4 to maxDB 7.5

Andre.Sudhofft-systems.com
Date: Tue Jul 06 2004 - 06:58:12 CDT

Hi Tilo,
 
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.
 
1.
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 ?
 
 
2.
Can I replicate a user directly from my old database 7.4 to my new one 7.5, without writing to a file ?
 
3.
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?
 
Best regards
Andre
 

>-----Original Message-----
>Hello Andre,
>
>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.
>
>Best Regards,
>Tilo Heinrich
>SAP Labs Berlin
 

>-----Original Message-----
>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 ???
>
>Best regards
>Andre