ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy schema objects (https://www.excelbanter.com/excel-programming/392997-copy-schema-objects.html)

[email protected]

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