Hi Sudhakar, [Sudhakar wrote] > Subject: About replication > > Can any one tell me how exactly the replication can be done > in SAP DB. This > is what I understood please correct me if I am wrong. > > Step 1. > Etract the data using DATAEXTRACT from sapdb into a file(is > this a text file or a propritery file format). > Almost right. You can extract data using the DATAEXTRACT or TABLEEXTRACT command with Replication Manager (the name Replication Manager is here somewhat misleading - a better name at this point in time would be ETL Manager). Anyway - the first command creates text file (and binary - this depends on the file format you use). The second command creates a proprietary format.
> Step2. > Insert the data from the file into the other Database using > TABLELOAD or FASTLOAD etc... > The same as above applies here - almost right. If you have extracted the data using DATAEXTRACT you may load it using DATALOAD or FASTLOAD. If you used TABLEEXTRACT you can only use TABLELOAD to load those data because of the format. > I would also like to know if there is any way of etracting > only the new data > since the last extraction, or either depending on the date and time of > records inserted. > Extracting new data with RepMan would only be possible by means of SQL in the command inself (keep in mind that a DATAEXTRACT command is similar to a SQL Query except of the outfile definition and the column descriptions - an example would be 'DATAEXTRACT * from <table name> where ... OUTFIELDS ... OUTFILE ...'; see the Replication Manager manual for the details) There is no RepMan command that extracts the data beginning at a certain point in time or only the new data. But when extracted all data you may on the other hand selectively insert those data into another table by specifying the duplicates clause in the DATALOAD command (possible only with this command - see the manual for details). HTH a bit. If not or in case of further problems let me know. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
