DB Level Extended Properties
alex.weatherall
Posts: 54
Hi,
Just noticed a recent conversation with SamJones11 about DB Attributes. If you do consider adding these then I have an additional request. DB Level Extended Properties - I set a number of Extended Properties against my DBs and when I change other objects, these are migrated, but if just the DB properties are different then there is no way to use SQLCompare to synchronise them.
The way I'd envision DB Properties and Attributes working in SQL Compare is one of 2 ways:
a single object of type Database and all the attributes and extended props as a series of DDL statements in the one object
or
to have the GUI show the attributes as separate objects of Database Type with the attribute name as the name of the object and the Extended Properties in an object called Database Extended Properties.
What do you think? As you said you might be looking at it :-).
Just noticed a recent conversation with SamJones11 about DB Attributes. If you do consider adding these then I have an additional request. DB Level Extended Properties - I set a number of Extended Properties against my DBs and when I change other objects, these are migrated, but if just the DB properties are different then there is no way to use SQLCompare to synchronise them.
The way I'd envision DB Properties and Attributes working in SQL Compare is one of 2 ways:
a single object of type Database and all the attributes and extended props as a series of DDL statements in the one object
or
to have the GUI show the attributes as separate objects of Database Type with the attribute name as the name of the object and the Extended Properties in an object called Database Extended Properties.
What do you think? As you said you might be looking at it :-).
Alex Weatherall
TeleWare.com
TeleWare.com
Comments
Thank you for the feedback, this will be considered for a future release.
Thanks again.
Redgate Foundry