Hi, I have a previously functioning java webapp, developed in Intellij, that used Tomcat 9. There should not be any need to change any of the code as it is a database set up and deployment challenge (this is harder than it sounds). I also have a .sql script. The webapp uses MySql. Although I set it up in MySql Workbench originally, it was set up for us on the school server a year ago (this no longer exists as I graduated). I would really like to set my school project up on its own with my own cloud account somewhere. This could be on Azure, AWS, or serverless, such as on Digital Ocean. I actually have some directions for deploying it on Digital Ocean but am having trouble understanding some of it. I had done an Azure tutorial, so I have been trying that first.
I have been trying to use Azure MySql Server, but ran into problems with actually having access to mysql just on my local machine from MySql Workbench. The connection to Azure worked fine. Unfortunately, I cannot migrate my tables or .sql script that I generated to the Azure database. I have a name for the database in Intellij for Java and did try to set up the connection string in the Context file. I run into problems when trying to deploy the webapp, however, as I do not know how Maven actually works, especially with Azure on a Mac (I am using Mac). We simply uploaded the .war file during the class. I am also a bit confused about the name of the database referred to in Intellij vs the name of the database in Azure. Should the name of the database inside of the .sql file be the same as the Azure database name or the name in Intellij, for example?
I edited the Gradle and Context files from school as minimally as possible, just specifying the connection string, login, and password for Azure.
Maven is in there but I do not know how to actually do the deployment.
Is anyone able to help me deploy this webapp? Ideally I would really like to edit the data in the database on MySql Workbench, but could copy paste into Azure if I know where and how. I am on CST but can adapt to other timezones. I am not using Github with this project and need to screenshare on my machine.