Hi. I've been trying to figure out what's the best (quick, compact etc.) way to dump database (tables, indexes, data) and import it to a different database which has the same table structure but different name, size, users etc?
I managed to do it this way: 1. Do a catalog extract to a file. 2. Do a CSV dump of all the tables (pain in the ass if there is hundreds of tables...DATAEXTRACT * FROM MYTABLE1 OUTFILE...) 3. Create new database 4. Rename database in catalog dump file if needed (new database name) 5. Do a catalogload to import table structure and indexes. 6. Do data load on all the CSV data files (again, pain in the as if there's many tables). I bet there's an easier way? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
