locked
Export to dacpac and FILLFACTOR RRS feed

  • Question

  • Hi.

    I need to export a database to a dacpac so that I can import it into azure. Hawever, I cannot get SSMS 2012 to export to a dacpac because all the indexes have a FILLFACTOR setting specified on them. Rebuilding them with a setting of 0 or 100 does not work. I need the setting completely removed.

    What options do I have?


    Cool signature, cool guy.

    Wednesday, November 7, 2012 9:37 PM

Answers

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

    • Proposed as answer by Kalman TothEditor Friday, November 9, 2012 4:37 PM
    • Marked as answer by Maggie Luo Sunday, November 18, 2012 3:26 PM
    Wednesday, November 7, 2012 10:41 PM