Hi Zahra, [[EMAIL PROTECTED] wrote]
> Subject: Export/Import > > > How do I export multiple tables from one db to another? I > know how to do table by table. > It depends. If you want the data stored readable in files you could write a script running all dataextract commands for all tables wanted. If you accept proprietary format you could use the commands TABLEEXTRACT USER or TABLEEXTRACT ALL. These commands generate data files which contain the data as db pages. This allows really fast extract and load. The commands extract all tables of a user or all tables found in the db. To load the data on the other side you must use the corresponding commands TABLELOAD USER or TABLELOAD ALL. There is so far no possibility to extract/load a specific number of tables with a single command. There will come some major changes with 7.4 but I can't promise any release date. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
