| hot to copy all data to a new schema [message #428917] |
Fri, 30 October 2009 14:25  |
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
|
Senior Member |
|
|
We maintain two schemas one for development and one for testing
developers makes changes to development schema and every time before testing we drop the testing schema and recreate from development schema.We use small sql script which copies all object from one schema to other , I need help or suggestions in copying data, we have lot of infrastructure data and its hard to write in sql or script which populates this , so I looking for some way which copies data from schema to other , we have toad is there anything in toad which can do this or are there any scripts available to do this ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
