Search

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

Closed
as Not Reproducible Help for as Not Reproducible

1
0
Sign in
to vote
Type: Bug
ID: 775835
Opened: 1/4/2013 1:44:52 PM
Access Restriction: Public
0
Workaround(s)
0
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)

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Windows 7 Enterprise (SP1)

Operating System Language

US English

Steps to Reproduce

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.

Actual Results

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'.

Expected Results

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

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 1/25/2013 at 1:34 PM
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
Sign in to post a workaround.