Hi Ajit, [ajit_cus wrote]
> Subject: Migrating data between ORACLE and SAPDB > > > Hi, > After porting my schema from ORACLE to SAPDB(wasn't as > simple as I thought. [snipped 9111 error desc] > My current data porting mechanism involves > 1 export each ORACLE table to a separate file using toad. (a > free oracle client) > This generates a file with an insert statement for each row. > 2 Parse the insert statements in each file to replace ; with // > 3 Use repmcli to run the file(s) and add data to SAPDB > > This mechanism works ok except : > a. Takes a long time(20+ mins) to parse the files and replace > ; with // as some files contain upto 0.3 million records. > Also takes a still longer time(40+ mins) to run each file > with repmcli. > Yep, each insert is executed individually. So this sums up. > b. Since each table is being exported individually the order > in which I import them into SAP DB becomes crucial due to > referential integrity constraints. > Yes, but this remains true even if you use the repmcli in a way it is build for. > Can someone who has migrated data between ORACLE and SAPDB > suggest a better method?(Preferably using free tools) > Is there a way to insert large number of records into tables > without using a huge number of insert statements in SAPDB? > Do you have the possibility to export your data from ORACLE in CSV (CommaSeparatedValues) or in FWV (FixedWidthValues) format? If yes you could build RepMan commands that simply read these data files and import them a bit faster (mass inserts or even generating db pages). I'd assist in building these commands ;-) Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
