Post reply

Import bacpac error in SQL Azure

  • March 26, 2018 at 2:25 am

    #344120

    Hi Everyone,

    I'm trying to import a bacpac (from an existing SQL Azure database) on to the same SQL Azure Server (under a different name) and I'm getting the following error message:

    TITLE: Microsoft SQL Server Management Studio------------------------------Could not load package from 'D:\Temp\20180323.bacpac'. (Microsoft.SqlServer.Dac)
    ------------------------------
    ADDITIONAL INFORMATION:Item has already been added. Key in dictionary: '4294967295'  Key being added: '4294967295' (Microsoft.Data.Tools.Schema.Sql)
    ------------------------------
    Item has already been added. Key in dictionary: '4294967295'  Key being added: '4294967295' (mscorlib)
    ------------------------------
    BUTTONS:OK
    ------------------------------
    Does anyone have any ideas what could be causing the issue?

    Thanks in advance for your help.

    Andy

  • March 29, 2018 at 2:33 am

    #1984916

    When the bacpac was taken, was the database in use? 

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export

    Specifically

    • For an export to be transactionally consistent, you must ensure either that no write activity is occurring during the export, or that you are exporting from a transactionally consistent copy of your Azure SQL database.

  • March 29, 2018 at 8:21 am

    #1984959

    Hi,

    Thanks for the reply, there was no write activity on the database, I'd disabled all account except the one which was being used by the bacpac and checking the logs it was the only account accessing the database.

    Thanks for your help.

    Andy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply