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 :-)
Regards, Kolja -----Urspr�ngliche Nachricht----- Von: Schildberg, Steffen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 6. Mai 2002 15:35 An: 'Kolja Kleist' Cc: [EMAIL PROTECTED] Betreff: RE: Migrate adabas db to sapdb [Kolja Kleist wrote] > Subject: Migrate adabas db to sapdb > > Hallo, > > I want to migrate a db from Adabasd to Sapdb! > I use my own jdbc-program to export and import the > tables/data between both > databases. The main problem i have in the moment is the following: > The tables in the adabas db uses char(8)byte key columns. The keys are > generated with the 'STAMP' keyword during insert. In the > first step, I want > to do the same on sapdb. Therefor I have to increment the > sequence that > produce the keys on sapdb to the same (or greater) value I have in the > adabas db. > Writting a perl/java/c program to do this is not the problem, > but the time > the program(db) will need to generate > 50.000.000 keys is a problem. > If there is a better way, please let me know!!! If there is > no better way to > do this, please let me also know. > What about using Replication Manager? Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
