Copying data between two schemas
I have two identical schemas in two databases I need to copy data between them.
Is there any script to export the data from first schema, delete the data from second schema and import first schema's data.
I do this multiple times every day and if someone can suggest a script, it would save my life... :D :D
Re: Copying data between two schemas
Quote:
Originally posted by sureshot
I have two identical schemas in two databases I need to copy data between them.
If they are identical why do you need to copy from one to the other :-)