Aki, I found the SAPDB tools difficult to use, so I wrote a dbreplicate utility in Java that uses JDBC to copy tables between live databases. There is no need to take the databases offline in order to run the utility. The databases don't have to be running on the same computer, nor do they need to be using the same DBMS (Oracle-SAPDB, Access-Interbase, etc). The utility is rather simplistic, but could easily be extended for special circumstances. Contact me if you would like a copy.
Mike > 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 > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
