Error Importing Azure bacpac file to local Db error incorrect syntax near EXTERNAL
This article concerns the following Stack Overflow question: Error Importing Azure bacpac file to local db error incorrect syntax near EXTERNAL which also encountered. In my issues, I was dealing with a 5Gb file and could not edit the needed files. TLDR: Rather than using the accepted solution from the Stack Overflow link, I had to go through creating a new database on azure and removed the external authentication provider manually. I was able to export the database in the Azure portal which forced me to use then download it again in a blog so I could import locally. Notes I did run into this issue, Is there a way to successfully import a bacpac that exceeds 4GB in which I need to change the Collation? What I did was moved the file locally to the server, from there I was able to get around the limit. At least that's what I remember at the time of writing I had always completed this project but forgot to document it but I believe that is what I did. Separated Environment Becau