One option is to rebuild the index through TSQL and leave the FILLFACTOR property off. I just did a quick check on my SQL Server 2012 instance and it worked. Here are the steps I tried:
-- Step 1 - Create table
create TABLE t1 (i INT PRIMARY KEY, j INT)
-- Step 2 - Create index w/ fillfactor
CREATE INDEX IX_ForumTest ON t1
(i, j)
WITH (FILLFACTOR = 80);
GO
-- At this point, Export BACPAC fails due to fillfactor property
-- Step 3 - recreate index w/ fill factor property removed
CREATE INDEX IX_ForumTest ON t1
(i, j)
WITH (DROP_EXISTING = ON);
GO
-- At this point, Export BACPAC succeeds
Thanks,
Sam Lester (MSFT)
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click
"Mark as Answer" and
"Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
