I'm thinking of doing the following to migrate a large (20GB) SAPDB6.2 database to 7.x:
on SAPDB6.2: - use xload to do a "CATALOGEXTRACT USER" (basically to recreate the sequence/view definitions) - use xload to do a "DATAEXTRACT FOR DATALOAD ..." for all tables of this user (all data belongs to one user) then: - modify the catalog result file to only contain the view and sequence definitions (remove all CREATE TABLE/INDEX statements since those will be done with DATALOAD for these tables) on SAPDB7.x: - create the target database and user - use xload/repm to do a DATALOAD for all the command+data files of all tables from the above DATAEXTRACT - use CATALOGLOAD to load all the view and seqeunce definitions Could this actually work? The problem I have here...does the DATALOAD actually perform referential integrity checks? If so, is there a tool or anything that could help in bringing all DATALOAD statements for all tables into the right order so the referential integrity is not violated? I already heard that its not possible to use single files created with TABLEEXTRACT USER on SAPDB6.2(or ADABAS D) to load them into SAPDB7.x because something in the internal format has changed (maybe page size?). I think it would have been the easiest thing to to a TABLEEXTRACT USER to get all tables into the new DB without having to worry about referential integrity. I hope someone can give me some hints :) Thanks alot, Marco _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
