Hi Tex
> Hi all,
> I have v7.4 installed up and running.
> I need to install it on to another server and was wondering
> if I can generate create scripts of the tables, indexes, etc.
> from the existing database so that I can run them in the newly
> installed server and have the same database created automatically.
Steps in order to export the structure and content of a table:
Prepare a file command.txt as follows:
USE USER <username> <password>
SERVERDB <databasename> ON <servername>
//
DATAEXTRACT FOR DATALOAD TABLE <tablename>
OUTFILE '<tablename>.data'
OUTFILE '<tablename>.command'
[EOF]
Execute the command.txt by typing
%> loadercli -u <username>,<password> -d <databasename>
-n <servername> -b command.txt
You'll get two files; one with all data rows, one with a script
that builds the table structure.
If you use the output of "SELECT TABLENAME FROM DOMAIN.TABLES
WHERE TYPE <> 'SYSTEM'" as input for the DATAEXTRACT commands
in command.txt (manually or by writing some script), you should
get what you wanted.
Christian
--
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Jetzt ein- oder umsteigen und USB-Speicheruhr als Pr�mie sichern!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
