Last post Apr 25, 2013 04:02 AM by Angie xu - MSFT
Apr 18, 2013 03:30 PM|wannabe67|LINK
I'm not sure if I am asking this correctly, but I'm going to try.
At my new job, we have a sql server data farm and when changes are made to the ASP code, most everyone makes the changes online (they connect to our ISP and straight to an IIS folder the ISP has setup). Since it is classic ASP and not compiled, I guess they
can get away with doing it that way. I'm going to be upgrading them from classic ASP to MVC and would like to work on my laptop and not have to rely on being online and connected to the ISP's virtual directoy all the time to work (like right now when I am
at home). We have many connection strings to many databases and it is not feasible for me to set up all databases on my laptop and I do not want to modify the config file with my laptop information and accidentally write that to the ISP's virtual directory.
I hope this is clear and someone can offer some adice. Thank you.
Apr 25, 2013 04:02 AM|Angie xu - MSFT|LINK
We have many connection strings to many databases and it is not feasible for me to set up all databases on my laptop and I do not want to modify the config file with my laptop information
I think you should connect to these multiple databases, or data can't be updated properly in certain databases, this will give you some tips to connect to multiple servers,
For reference -
How to: Connect to Multiple Databases
Moreover, you could consider get help from
SQL Server forums for this issue, I think more professionals will share experience with you,
hope it helps you,