View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jhofmeyr@googlemail.com is offline
external usenet poster
 
Posts: 2
Default 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?