Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy all formats and objects | Excel Discussion (Misc queries) | |||
copy objects false | Excel Discussion (Misc queries) | |||
Copy Worksheet wont copy objects. | Excel Worksheet Functions | |||
how do I copy all cells and all objects in a sheet together? | Excel Discussion (Misc queries) | |||
Copy a folder and objects | New Users to Excel |