Hi there, i have to replicate a database. So at first I had tried to make a complete backup and copy the media to the new server and had tried to recover this medium. I figure out that after the successfully recovery process could not be set online any more. ;( The dbm gui give a absolutely stupid error (connection broken). As next I had made a sql dump of my tables and had tried to import them as sql via jdbc. Since the sql statement was to big for the jdbc driver it fails again. No I had used the loader tool, but I get an error here as well. ;( I had followed each step described under: http://sapdb.2scale.net/moin.cgi/MigrateDbUsingLoader73 My command.dat looks like SET MAXERRORCOUNT 50 // USE USER user password SERVERDB jboss ON myserver.de // DBEXTRACT OUTFILE 'ddlfile' OUTFILE 'datafile' // USE USER user password SERVERDB jboss ON myserverRemote.com // BLOAD ALL INFILE 'ddlfile' INFILE 'datafile' OUTFILE 'restartfile'
But I get an error: USE USER user password SERVERDB jboss ON myserver.de Error during execution -->-25281 Syntax error at position 40 (Unexpected token: myserver.de). Defined maximum number of errors (1) reached 1 error(s) during execution of command file 'command.dat'. Since the sample is for 7.3 I'm not really sure if the command,dat is right, but it is linked as 7.4 example as well. Someone can provide me an example ho to migrate 2 sap database using the loadercli? Thanks Stefan _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
