Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mark_anderson_us
Starting Member
1 Post |
 Posted - 2008-12-10 : 10:02:14
|
| Hi AllWe create quarterly versions of DB's (so we have Q108, Q208, Q308, etc.)Back in Q2 we documented the database using extended properties and then wrote T-SQL to extract the complete definition to Excel. When we start working on the development of a new quarter (e.g Q408), we backup the previous quarter (e.g. Q308) and restore it to the current quarter (e.g. Q408). The problem is, this does not bring the extended descriptions with it. So two questions:How can I copy the extended descriptions from Q2 to Q3 and Q4?Is there a better way to copy the DB (without any third part tools) at the start of the quarter that would also copy the extended descriptions?Thanks in advanceMark |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-17 : 07:02:08
|
| They can be displayed using the system view: Select * from sys.extended_propertiesI did a backup and restore after adding a test extended property and the property was visible in restored db (using SSMS) and using the view.It may be due to:"the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission."You can update the system view using: sp_addextendedproperty. So if they are not coming across you should be able to script an update from other db. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 07:13:49
|
| also you can use ::fn_listextendedproperty to view extended properties of table/column |
|
|
|
|
|
|
Copying Extended Properties