RE: Problem loading data from SapDB 7.4 to maxDB 7.5

Hi,

Wlid Yemah [mailto:wyemah@xxxxxxxxx] wrote:
> 
> Under SapDB 7.4 I unloaded the catalog and data of my
> database 'birds' like this:
> 
> DBEXTRACT CATALOG OUTSTREAM 'birds.catalog' DATA
> OUTSTREAM PIPE 'birds.data'
> 
> it worked fine.
> 
> Under MaxDB 7.5 I created a database instance 'birds'
> and then tried to load the catalog and data which I
> already extracted:
> 
> DBLOAD CATALOG INSTREAM 'birds.catalog' DATA INSTREAM
> 'birds.data'
> 
> The catalog has been successfully loaded but not the
> data. I get the error:
> ERR -25603
> Error processing TABLELOAD; Loader versions used for
> TABLEEXTRACT and TABLELOAD differ (TABLEEXTRACT:
> 7.4.03, TABLELOAD: 7.5.00)
> 
> Please any clue on how to solve this issue?
> 
Yep, you should use the same Loader (version) to solve both -
extracting and loading the data. As you already have the catalog
extracting the data is sufficient. I'd suggest to use the Loader
of the higher version to extract and to load the data.
So you could run slightly modified statements to extract:
DBEXTRACT DATA OUTSTREAM PIPE 'birds.data'

and to load the data:
DBLOAD DATA InSTREAM PIPE 'birds.data'

You can simply replace the older Loader on your server with 'birds' of
version 7.4 with the Loader of version 7.5 and it should work.
Or you could do the export remotely which takes some more time, of course.

Sorry for any inconvenience.
Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx