Can I create a dacpac including data in SQL Server 2008?

Question

Can I create a DACPAC including data in SQL Server 2008?

My requirement is to generate the incremental script of the DB changes, would I be able to do that using BACPAC?

I tried reading this, but this is not much helpful:

https://msdn.microsoft.com/en-us/library/jj860455(v=vs.103).aspx

Answer 1

You can use SqlPackage.exe tool manually found actions here.

Use Export action as:

sqlpackage.exe /action:Export /TargetFile:"test.bacpac" 
    /sourceDatabasename:test 
    /sourceservername:.\testserver

Use Extract action as:

sqlpackage.exe /action:Extract /TargetFile:"test.dacpac" 
    /sourceDatabasename:test 
    /sourceservername:".\testserver"
    /p::ExtractAllTableData=true

• Source is here

By default, data for all tables will be included in the .bacpac file.