Toad World® Forums

Copying tables in SQL

We're doing some dev work on a sandbox database, once that work is approved I will need to move the tables used for testing from dev to prod. I was hoping TOAD had a way to complete this task.

Any suggestions?

Thank you.

Toad has the capability to either create the DDL for any/all tables for the database, or you can possibly use the Schema Compare facility to create a sync script that will make source look like target.

Where can i get more info about the sync script approach?

Thank you.

Hi,

You can use Schema Compare for it. Compare your source database with any empty database
Check Schema Compare Help for more info