This is going to be fixed in VS 2010 since you're going to have a config file to development, a config file to production, etc. You'll appoint the database with the IP in your development config and in production config (the published one), you'll appoint it as localhost.
I can't see why it is a problem the published app appoint to the IP since it is going to be find faster than on any other machine (since it will be localhost). Anyway, you could develop on a machine and use some kind of source tracking tool (tfs, sourcesafe), check-in the modifications, get and publish on another machine (which is already pointing as localhost/MSSQL in config file). An ugly solution would be to replace the config file everytime you publish your app.. :P On Mon, Oct 19, 2009 at 6:35 AM, Jamie Fraser <[email protected]>wrote: > I'm not totally sure what your problem is... > > You have a local app and a (should have) local DB. You should have an > instance of SQL Server running locally on your dev machine. You refer to > this using a standard connection string. > > When you "publish" your app, you update the relevant connection string to > point to SQL Server on your remote machine (you might find that it doesn't > need to change). > > To ensure data is consistent between your local machine and your remote > machine you can use something like replication. > > > On Sun, Oct 18, 2009 at 3:25 PM, B☼gus Excepti☼n <[email protected]>wrote: > >> >> 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 >> :) >> > > -- Atenciosamente, Paulo Roberto S. Pellucci
