Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export SqlDatabase to Bacpac using SqlPackage.exe fails on fillfactor

I am using the following command to execute sqlpackage to export a bacpac for a local db.

"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe" /action:Export /tf:".\dbname_Baseline.bacpac" /SourceConnectionString:"XXXXXXXXXXXX"

It fails saying "Element Primary Key: [dbo].[PK_Name] has an unsupported property FillFactor set and is not supported when used as part of a data package."

I understand fillfactor is not supported but is there anything to make it ignore unsupported properties?

Thanks

Mark

like image 226
peter pan Avatar asked Aug 31 '13 22:08

peter pan


People also ask

What is SqlPackage EXE?

SqlPackage.exe is a command-line utility that automates the following database development tasks by exposing some of the public Data-Tier Application Framework (DacFx) APIs: Version: Returns the build number of the SqlPackage application. Added in version 18.6.


1 Answers

Pass the switch

/p:IgnoreFillFactor ={ True | False }
like image 128
Eoin Campbell Avatar answered Oct 16 '22 13:10

Eoin Campbell