How to update the database in Azure?

Question

ASP.NET

Hello everyone,
I see the process of developing and maintaining the site as follows: there is an ASP.NET MVC project itself, there is a local database for it (MS SQL). I changed something in the database, maybe the scheme (this is solved by migrations), more often - the data. All tested locally. Now I just want to upload this database to Azure. The paradox is that there are no normal options, well, or I didn’t find them.
1. I can connect to Azure from SQL Management Studio and execute any scripts. But my first task is to update the pages of the site. Pages prepared in files. Wrote a script that reads a file, writes it to the database. But it is clear that the file is being searched relative to the server, i.e. he is looking for it not on my computer, but on Azure.
2. There is an option to publish in Azure - it works fine. But for some reason it does not allow to do it a second time, i.e. restart the base. Swears that this already exists. And what should I change the name of the database for each release?!
3. It seems like it's possible through BACPAC. I'm trying to unload the local database by specifying Azure Storage. Errors are rolling in. And I don’t want to complicate the process so much, use intermediate steps, pay for storage on Azure.
Tell me how to make it easier?

Answer 1

Here it is advised to create a dbproj and use it to generate an Update script