Importing BACPAC file from azure to SQL creating an empty database
2
votes
1
answer
4509
views
Exported Data-Tier_application from an Azure database to create a BACPAC of it.
> SQL editions I'm trying to use to import the BACPAC:
> SQL Server 2016 express.
> SQL Server 2017 Developer Edition.
I droped some views and procedures to fix error and it fixed everything.
I have now a 3GB BACPAC file and when i'm trying to import it(right click - import data tier application on databases menu from SSMS ) to my SQL Server 2016 or 2017, I receive this error:
with this error message:
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Could not import package. Warning SQL72012: The object
> [DATABASE_NAME_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
> Warning SQL72012: The object [DATABASE_NAME_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
>Error SQL72014: .Net SqlClient Data Provider: Msg
> 7609, Level 17, State 5, Line 2 Full-Text Search is not installed, or
> a full-text component cannot be loaded. Error SQL72045: Script
> execution error. The executed script: CREATE FULLTEXT INDEX ON
> [dbo].[Table]
> ([Nome] LANGUAGE 1033, [field_1] LANGUAGE 1033)
> KEY INDEX [PK_Table]
> ON [table];
it's not possible to have already these DATA and LOG because It's the first time I'm restoring it.
Changing .BACPAC file to .ZIP I could see a DATA folder with a lot of BCP files:
The bacpac file has 3GB.
Other answers from websites just say : "wait until the end" but the export ended 4 days ago.
I have another BACPAC file from a different database and I can import it to sql server normally. I've made the same steps for both BACPAC files when exporting.


Asked by Racer SQL
(7546 rep)
Aug 15, 2019, 12:19 PM
Last activity: Aug 23, 2022, 10:00 PM
Last activity: Aug 23, 2022, 10:00 PM