If you have a relatively small database you could use the following: 1. Use db2look to create the DDL for the database you wish to copy. 2. Use db2move to extract the data. db2moves use a file called db2move.lst to keep track of the tables it is moving data from. 3. Change the schema in the DDL and Create the new database. 4. After copying the files created by db2move to server B, edit db2move.lst to have the new schema name in it. When you run db2move to import the data into the new database, it will put it in the tables with the new schema.
You have to be careful in editing the db2move.lst file, but this technique will work. I mentioned that you should do this with small database, because db2move uses imports and exports, which are not extremely fast. Shirley Fan wrote: > Hi all, > I am running UDB7.1 on NT4. > Is there a way to copy a database from the server A to server B and change > the schema (table qualifier) from XXX to YYY ? > > TIA, > Shirley. > > ------------------------------------------------------------------------ > Name: Disclaimer.txt > Disclaimer.txt Type: Plain Text (text/plain) > Encoding: 7bit ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
