Hi Kolja, [Kolja Kleist wrote] > Subject: AW: Migrate adabas db to sapdb > > Hallo Steffen, > thank you for your quick response. > What do you exactly mean with using the Replication Manager? > Should I load > my data with the Replication Manager? Does the Replication Manager > automaticly increments the internal sequence if there are char(8)byte > primary key columns? Should the Replication Manager create > new keys with the > 'STAMP' keyword? What happens with foreign keys in this case? Does > Replication Manager supports a command to increment the > internal sequence? > Sorry about the flood of questions :-) > Well, Replication Manager does what XLOAD does: loading data that was extracted by XLOAD or RepMan (or any other tool thats able to create data in a format 'readable' for both tools). As far as I understood you want to migrate from ADABAS to SAP DB, right. Hmm, you could CATALOGEXTRACT your catalog from ADABAS and CATALOGLOAD it into SAPDB. You could use DATAEXTRACT FOR DATALOAD to extract the data from ADABAS (and to create the DATALOAD commands). Doing this is only possible for single tables so you might need a script that brings the tables to extract into right order (foreign keys). Then you could use the data file created and the DATALOAD command (with slight modifications - syntax is almost the same for XLOAD and RepMan) to get the data into SAP DB. In case the DATAEXTRACT FOR DATALOAD command creates the right commands to get the data into an ADABAS db we'll get it into SAP DB. So I would answer your questions above with yes.
Lets try it with one command. If it works - go ahead. If not I'll improve the RepMan so that there is no need to write your own script for this kind of work in the future :-)) Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
