What I mean is, in VS I make a reference to a local DB, because on the target/published server I have a MSSQL 2005 there (not on the local VS machine).
So I want to test (F5) my solution while in VS, but that would mean having a reference to my MSSQL 2005 database via a URL, as it is remote. The problem comes in when the solution on VS is "published" to the remote machine where MSSQL is. Will the app refer to the database the same way it did in VS? I assume so. In that case, the app has to go out to the IP stack to find the data. Clearly, it would be better to have the app interact with the database direct without using the ip layer at all. So how can I wrote a solution in VS that will work directly with a local db that is only local once published? Do I need to somehow recreate the db on the remote machine in my local instance? How would they stay in sync? Replication of some sort? Interested in your thoughts. pat :)
