[SSDT] Database extended properties are improperly deployed to localdb

[SSDT] Database extended properties are improperly deployed to localdb by eskarina

Closed

as Not Reproducible Help for as Not Reproducible

Type:	Bug
ID:	775835
Opened:	1/4/2013 1:44:52 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

If extended properties are created at the database level on an SSDT DB project, deploying to localdb multiple times results in an error under certain deployment settings. See repro steps for details.

Details (expand)

English

SQL Server 2012 - Standard Edition

Developer Tools (SSDT, BIDS, etc.)

Windows 7 Enterprise (SP1)

US English

1. Create an SSDT database project.

2. Add an extended property to the database, e.g.

EXECUTE sp_addextendedproperty @name = N'foo', @value = N'bar';

3. Under project Properties -> Debug -> Deployment Options, make sure the following are set:
"Always recreate database" is UNCHECKED
"DROP objects in target but not in project" is UNCHECKED
(Under Advanced) "Ignore extended properties" is UNCHECKED

4. Deploy to localdb. The deployment will succeed.

5. Deploy to localdb a SECOND time. The deployment will fail.

Deployment fails with error message: Error: SQL72014: .Net SqlClient Data Provider: Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37 Property cannot be added. Property 'foo' already exists for 'object specified'.

The deployment should succeed. It should detect that the property already exists and not attempt to re-create it.

0 attachments

eskarina,

Thank you for your feedback regarding incorrect deployment of extended properties on repeat deployment to localdb. However, at this time, I am no longer able to reproduce this issue using the latest version of SSDT. Please make sure you are using this latest version which can be downloaded from here - http://msdn.microsoft.com/en-us/data/hh297027.

Thanks, and please let us know if you have any additional questions or feedback!

Adam Mahood
Program Manager
SQL Server Database Systems