I'm getting ready to build my first ASP.NET/SQL Server website that will be hosted on some web host out there (long distance, different network). The work I've done in the past (pre-.NET) was all done on in-house servers.
Since this website/web-app will be hosted elsewhere, I wanted to ask some questions to make sure that I'm doing things correctly.
We have a SQL SQL 2012 db hosted on a server here. I need to build a website (hosted remotely) that will both read and write data from this database as well as a couple of other SQL SQL 2012 (maybe 2014 also) databases located on
machines here.
What is the best way to accomplish this via a hosted setup it on hosting provider? I plan to host my site with http://www.hostforlife.eu.
What features do I need to make sure I have when trying to select a web hosting provider?
What is the best method for accessing the databases here from the remotely-hosted website? I want to make sure I'm using the best methods for speed, security, stability, etc.
Will I just access the SQL Servers here directly, or do I need to have a SQL Server running at the web host also some type of a subscription setup? I asked these question in another group and I was told to use replication to
keep a copy of the databases local to the web host for performance reasons.
Any recommandations for quality ASP.NET web hosting providers in Europe? Any that you've had good service and results with?
I have no idea what the best way to accomplish this is and I'm feeling lost.
Thanks in advance for any and all information, I really appreciate it.