The topic contains information on how to transfer a table from one schema to another.
To transfer a required object, follow the steps below:
On the Source and Target tab specify the schema where you want to insert the table in.
Check Compare only mapped schemas.
Check the Use ALTER SCHEMA TRANSFER expression option on the Options tab of the synchronization wizard.
create schema sc1; GO create schema sc2; GO create table sc1.table1 (id int); GO
ALTER SCHEMA sc2 TRANSFER sc1.table1 GO
- You can only transfer tables between schemas from the same database.
- All permissions associated with the table that is being transferred are dropped when it is moved.
- Only beginning with SQL Server 2005, the Transfer option is available.