We are currently using a off the shelf ERP system. It lacks in several areas, one of those being quoting. So, I have been tasked with creating a quoting application that will need to use (in read only mode) data from the ERP system. The ERP database is stored on our local server (Windows Server 2012) in SQL Server 2014. Eventually the quoting application will reside on the same server (both the database and web app).
I plan on building the application in ASP.NET MVC 5 via Visual Studio 2013. I will be using code first to develop the quoting application. I will be using database first to pull over the classes for the existing database.
When creating queries, I will need to join the ERP tables with the new quoting tables. So, I am guessing I will need one data context.
My real struggles is how do I deploy this application. I basically don't need to deploy the ERP database, because it is already there. I do need to deploy the quoting database and the application.
I would like to get my plan of attack figured out before getting into it and realizing I need to do things completely different. I am somewhat new to Visual Studio and MVC, and I have never deployed a project. Any ideas on how to accomplish the above, including the data context issue?