Copy schema objects
Is there an easy way to copy database objects - tables (incl. indexes
and constraints) and views - from 1 schema to another? I am working on a project that requires the creation of new schemas with the same objects that exist in the dbo schema. The ALTER SCHEMA command only allows the transfer of objects. I am also interested in whether there is a recommended best practice for maintaining this type of database. Obviously if an object in the dbo schema changes, I would like this change to be rolled out across all other schemas as well. I am using VS2005 and Team Foundation Server to manage the db objects - is there perhaps a built in feature that I am unaware of that would assist with these tasks? |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com