Extended properties handling - suggestion
kanda
Posts: 4
Hi,
I use SQL Compare to synchronize database schema between local database (SQL Server) and remote Azure SQL Server. I have a lot of extended properties on the tables and the columns. Deployment wizard shows a lot of the exactly same warnings "High: Extended properties are not supported in the target database version."
Suggestion #1: Isn't it enough to display the warning once? Repeated entries give no more information.
When I user filter bar on the left side and uncheck "Extended properties" only extended properties on the database disappear. Extended properties on the tables are still used.
Suggestion #2: Should filtering extended properties filter ALL extended properties? Not just those on the database.
Setting "Ignore extended properties" in the option dialog works fine.
Thanks.
JK
I use SQL Compare to synchronize database schema between local database (SQL Server) and remote Azure SQL Server. I have a lot of extended properties on the tables and the columns. Deployment wizard shows a lot of the exactly same warnings "High: Extended properties are not supported in the target database version."
Suggestion #1: Isn't it enough to display the warning once? Repeated entries give no more information.
When I user filter bar on the left side and uncheck "Extended properties" only extended properties on the database disappear. Extended properties on the tables are still used.
Suggestion #2: Should filtering extended properties filter ALL extended properties? Not just those on the database.
Setting "Ignore extended properties" in the option dialog works fine.
Thanks.
JK
