Developing locally and deploying remotely - database access
Posted on 2008-10-09
I'm pretty new to .Net and am having some issues moving from classic ASP to ASP.Net. The situation I have is as follows.
I've a domain hosted by 1and1 which includes an MS SQL database. One of the issues I have is that you cannot link to the DB with a locally installed Enterprise Manager/SSMS, so I'm unable to write a client app that accesses my data on the host. As such, I need to make a web app that will allow me to carry this out.
I could use ASP but think I need to update my skills somewhat but unfortunately, amongst the multitude of guides and articles I've not found anything that suggests a solution to this specific problem. Essentially where previously I would make a local copy of the database, develop for that and then change my connection string when uploading I don't know whether that's a) possible or b) appropriate when using .Net.
So, at last, my question is. If I develop a web app locally can I change the connection string (or equivalent) after deployment on the application server so that it points to the hosted database, and if so, how?
I'd really appreciate it if someone could help or point me in the correct direction.
Oh, and I'm using VS2005 with SQL 2005, and would prefer any code suggestions in VB.Net.