Hi Everyone, I've used loadercli to extract my database catalogue to a flat file, so i can recreate a new database with the same schema on another server. I've used this line to extract the database catalog: loadercli -u dba,dba -d test_sap -n srv-test -b schemaextract.cmd
schemaextract.cmd contains only one line: CATALOGEXTRACT ALL OUTSTREAM 'u:\sapdb\schema.data' Now if i take a look at schema.data, i have: SQLMODE INTERNAL // USE USER ADMIN initial // CREATE USERGROUP ACHATS STANDARD EXCLUSIVE // CREATE USER CBONNAFOUX PASSWORD initial USERGROUP ACHATS // CREATE USER CMERVANT PASSWORD initial USERGROUP ACHATS // CREATE USER SCONDARCURI PASSWORD initial USERGROUP ACHATS // CREATE USERGROUP MAGASINS STANDARD EXCLUSIVE // CREATE USERGROUP MARKETING STANDARD EXCLUSIVE // CREATE USER ANUNEZ PASSWORD initial USERGROUP MARKETING // CREATE USER APILAS PASSWORD initial USERGROUP MARKETING // CREATE USER GMONTEIL PASSWORD initial USERGROUP MARKETING // CREATE USER LVIGNELLES PASSWORD initial USERGROUP MARKETING // CREATE USER PGALLOU PASSWORD initial USERGROUP MARKETING // CREATE USER PLEONET PASSWORD initial USERGROUP MARKETING // USE USER DBA DBA // CREATE USER ADMIN PASSWORD initial DBA NOT EXCLUSIVE // CREATE USER SYSINFO PASSWORD initial RESOURCE EXCLUSIVE // USE USER ADMIN initial // .... Now you can see that loadercli try to use the user admin BEFORE it is created ! Of course if i try to use this file "as is" to load the catalog to a fresh database, i get errors messages ( can't remember which ones, sorry ). If i put the lines USE USER DBA DBA // CREATE USER ADMIN PASSWORD initial DBA NOT EXCLUSIVE // CREATE USER SYSINFO PASSWORD initial RESOURCE EXCLUSIVE just after "SQLMODE INTERNAL", everythings run fine. Is it a bug in loadercli, or do i missed something ? TIA Fr�d�ric DEMILLY. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
