Hi Andreas, Andreas Grund [mailto:[EMAIL PROTECTED] wrote: > Subject: Re: Re: Again: Migration of a db-instance from win NT4 to Win > 2k > > > 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. > Right.
> 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? > You got it right, partially. You need to have the RDBMS installed and a DB instance created. But the DB schema and content may be delivered using the DBLOAD. The DBLOAD first creates the users (using initial passwords) and the whole catalog, and finally loads the data. Therefor it creates 2 files - as you already saw: one for the catalog and one for the data. The first file is a readable text file and the second is a binary file that shouldn't be changed. To have someone else copying your db on her pc simply deliver the second part of your script and the respective files (the part starting with the second USE USER). But be aware that this 'someone else' needs anyway to modify the script slightly to adapt the path settings and user names to her needs. > By the way: SAP DB 7.4.3.25 complains about the OUTFILE in > the second command. > Yep, use OUTSTREAM FILE instead. Same goes for INFILE (substitute with INSTREAM FILE). Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
