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.