Running queries on a mirrored database

by avidgamer   Last Updated May 31, 2017 17:06 PM

I have a Web forms asp.net site running with a database on a VM (VM1). I also have a MVC 5 Web app that has its own membership database on another VM (VM2). I want to retrieve customer information from VM1 to create a login on VM2.

My thoughts were I could create a backup database(or mirror) for VM1 to run member queries on that to retrieve information. Is this plausible? What methods would you recommend?

One method that I think I am able to obtain, would be creating a webservice on VM1, but it just seems the VM2 would be constantly using this webservice and I really want to obtain the best performance possible. Any help is much appreciated.



Related Questions


File system alternative to db

Updated July 28, 2018 18:06 PM


How to make a mobile/remote database interface?

Updated December 23, 2017 02:06 AM


service broker with mirroring

Updated August 22, 2018 13:06 PM