Physically Moving Data to Another Database

MOVE TABLE cannot be used if you need to physically move the table data from one database to another. In this case, you need to perform the following steps:

1. Use CREATE TABLE to create a new table, with an appropriate schema, in the destination database.
2. Use the INSERT INTO .... SELECT FROM statement to transfer the data from the source table to the destination table
3. Use the DROP TABLE statement to drop the original table.

You must also recreate any table objects, including indexes and fragmentation strategies, and verify that there is sufficient disk space to move the data.

Related Information