Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schema's migration

Status
Not open for further replies.

ofsouto

Programmer
Apr 29, 2000
185
BR
Dear Sirs
How can I migrate tables from one schema to another or change schema name?
DB2 7.2 (Windows).
Thanks in advance.
 
I don't think you can ..

If you are still in development, the best way from the application point of view is to create aliases ... May be, when you create the next time on a test/prd box , you can do it with the right schema

HTH

Cheers

Sathyaram


 
I used SQL tool to migrate objects/data from SQL-Server to DB2 and the tool create "OWNER" schema when the correct schema is OWNER. What can I do to change schema name or what can I do to migrate objects/data from "OWNER" schema to OWNER schema?
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top