J
jhofmeyr
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?
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?