> > If you wish to migrate from a non unicode database to a > > unicode database you have to use export/import of your data.
> so ist there an easy way to export all users, schemas whatsoever to a > file and import vice versa? Granted I have all needed rights (dba?) hi carsten, extract sapdb in the folowing way: - establish a repman session r1. - usw r1 to establish a db session db1 with sysdba privileges. - extract the catalog using the command catalogextract all outfile '<filename>' - extract the data using the dataextract command for every table in the db. use the same ordering of tables ( support of a extract db command is in work ) load sapdbdb in the folowing way: - establish a repman session r2. - usw r2 to establish a db session db2 with sysdba privileges. - load the catalog using the command catalogload all infile '<filename>' or use '<filename>' as a batch input of repmcli. - load the data using the dataload command for every table in the db. ( support of a load db command is in work ) assert: - the system catalog was generated with a sapdb version 7.3.0 or higher. - data and metadata ( catalog ) are ASCII_1 encoded. ( support of other sbc codepages is in work ) hans-georg -- Hans-Georg Bumes [EMAIL PROTECTED] SAP DB, SAP Labs Berlin http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
