Hi Kwok Peng Tuck, as far as i understood the homepage, my script must contain the following statements: SET MAXERRORCOUNT 1 // USE USER <src sysdba> <password> SERVERDB <src db name> ON <src host> // DBEXTRACT OUTFILE 'C:/Datenbank/Datenbank.ddl' OUTFILE 'C:/Datenbank/Datenbank' // USE USER <trg sysdba> <password> SERVERDB <trg db name> ON <trg host> // DBLOAD ALL INFILE 'C:/Datenbank/Datenbank.ddl' INFILE 'C:/Datenbank/Datenbank' OUTFILE 'C:/Datenbank/neu'
But this script can only work, if the soucrehost and the targethost are connect to each other. But i need a script or a batchfile, which i can burn on a cd with the backup of my original db and someone else copys the backupfile and the batchfile on his pc, startet the batch-file and after the execution of the batch-file sapdb has created a new database with the same content and the same tablenames and the same foreignkey... as my original db has. So, do i understand the loader wrong, or has the database to be create before this script runs? By the way: SAP DB 7.4.3.25 complains about the OUTFILE in the second command. Greeting and thanks for your reply, Andreas Kwok Peng Tuck <[EMAIL PROTECTED]> schrieb am 06.08.03 08:34:27: > > Hello Andreas, > Have a look at this wiki over here : > http://sapdb.2scale.net/moin.cgi/MigrateDbUsingLoader73 > It should still apply to version 7.4. I've used it to migrate > between linux and win2k, so it should > work ok for you. Good luck. > > > > Andreas Grund wrote: > > >Hi Mailinglist, > > > >I send the Mail again, because noone react on my first mail and I have to solve the > >problem. Maybe someone can help me now: > > > >I tried since last Friday to migrate a database from Win NT to Win 2K. I work with > >SAP DB 7.4.3.25. First i make a complete databackup. I copied this file to the new > >machine and there i want to recover the database with dbmcli. But i fail every > >time, because on the new machine is no backuphistory. With the dbmgui, it no > >problem, but i wanted to write a batchfile, which does this job. Someone out of the > >mailinglist sends me an batchfile, but it does not work either. the *.knl file says > >everytime: > >3F2E48B70002| |HISTLOST | | |2003-08-04 13:51:19| | | | | | | | 0| | > >3F2E48B70003|DAT_00012|RESTORE |2003-08-04 12:48:34|2003-08-04 12:48:34|2003-08-04 > >13:51:19|2003-08-04 13:51:25| 2928| |NO |Datensicherung | 1072| 1| 0| | > > > >My batchfile contains: > >dbmcli -d KNL_SAMM -u ROOT,TELEKOM db_drop > >dbmcli db_create KNL_SAMM ROOT,TELEKOM > >dbmcli -d KNL_SAMM -u ROOT,TELEKOM -i D:\Datenbankrecovery\command.dat > > > >And in the command.dat stands: > >medium_put Datensicherung D:\Datenbankrecovery\KNL_SAMM.backup FILE DATA 1300 8 YES > >NO > >medium_getall > >service_connect > >recover_config Datensicherung > >service_release > >param_startsession > >param_put RUNDIRECTORY D:\programme\sapdb\indep_data\wrk\KNL_SAMM > >param_put DIAG_HISTORY_PATH D:\programme\sapdb\indep_data\wrk\KNL_SAMM\DIAGHISTORY > >param_checkall > >param_commitsession > >db_admin > >util_connect > >util_execute init config > >util_release > >util_connect > >recover_start Datensicherung DATA > >util_release > >db_online > > > >And the last command is the problem, it is not possible to set the new database > >online. Why?? Where is the failure? > > > >Greeting and thanks, > >Andreas > >______________________________________________________________________________ > >ComputerBild (15-03) empfiehlt: Der beste Spam-Schutz ist bei > >WEB.DE FreeMail Deutschlands beste E-Mail - http://s.web.de/?mc=021141 > > > >_______________________________________________ > >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 ______________________________________________________________________________ Wo gibt es den besten Spam-Schutz? Laut ComputerBild 15-03 bei WEB.DE FreeMail - Deutschlands beste E-Mail - http://s.web.de/?mc=021122 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
