none
SSDT generates 2012 option for target 2008 when target is a dacpac RRS feed

  • Question

  • I have a db project with target platform set to SQL Server 2008.

    I am using sqlpackage.exe to generate publish script to create new database. Sqlpackage target is set to a dacpacfile (just empty model without any tables).

    The problem is that publish script has few options set which are available only in 2012. The options are:

    ALTER DATABASE [$(DatabaseName)]    SET TARGET_RECOVERY_TIME = 0 SECONDS     WITH ROLLBACK IMMEDIATE;
    GO 
    ALTER DATABASE [$(DatabaseName)]    SET FILESTREAM(NON_TRANSACTED_ACCESS = OFF), CONTAINMENT = NONE WITH ROLLBACK IMMEDIATE;
    But when I generate publish script directly from VisualStudio and specify target database as real 2008 database (not dacpac) then resulting publish script is correct. It doesn't contains above options.

    So the question is why 2012 options are being generated when target is a dacpac even if target platform in the project is set to SQL Server 2008? My dacpac was generated through SSMS from an empty 2008 database.
    Friday, December 5, 2014 10:50 AM

Answers

  • Connect bug registered:

    https://connect.microsoft.com/SQLServer/feedback/details/1049478/ssdt-generates-2012-option-for-target-2008-when-target-is-a-dacpac

    Tuesday, December 9, 2014 10:26 AM

All replies

  • This does appear to be a product issue. please file a connect bug on this so we can properly track the issue. Please find the instructions for filing a connect bug here:How to file a Connect bug
    Sunday, December 7, 2014 12:25 AM
  • Connect bug registered:

    https://connect.microsoft.com/SQLServer/feedback/details/1049478/ssdt-generates-2012-option-for-target-2008-when-target-is-a-dacpac

    Tuesday, December 9, 2014 10:26 AM