Currently I have an internal CRM application that houses all my data and runs my entire company. The front end is ASP, and the back end is SQL. The external site will run SQL
What I'd like to do is to have an external site for customer's to log in, manage their accounts, etc., but I am very concerned about my data and data security. Are there any best practices that I can follow to "replicate" data to the external databases? Are there some suggested methods people have done in this scenario?
My goal is to have the two databases linked with certain data. Changes inside would be queued somehow to the outside, and vice versa. If it is live, that wouldn't be the end of the world either.