Last post Dec 20, 2010 01:19 AM by hemant.yadav
Dec 01, 2010 05:48 PM|artashkan|LINK
If there is a server and mysql DB on the server, so as a developer I need to work on local machine first but have access to server's database. Because it is very tedious to publish the site by each change and then see what happened, sometimes very simple
css fixing takes an hour to be fixed this way.
I need to know hot to make connections to my server DB or even copy that on local machine in the way that if I want to publish the site there is nothing to ifx or it is very easy to switch from local machine settings and configuration to server configurations.
This is a really headacke for me.
Dec 01, 2010 07:43 PM|Deeshal|LINK
I would suggest that you install MySQL on your local machine, do a backup of the database from the server and a restore on your local machine. You can then work with that database on your local machine - just need to change the connectionstring in the web.config.
Dec 02, 2010 06:07 AM|artashkan|LINK
Actually I have mySql installed on my local machine, but connection string is defined in a class in code behind, also we use some othere fitures that need server Url to run namely google map. I am seeking a way that makes us able to distinguish between local
machine and server and uses ConString accordingly.
Also if I find a way to publish a web site partially in Visual Studio it is still ok to use server, the problem is that I need to exclude many files each time that I need partial publishing. for example if I do change on one page and want to publish this
page with its code behind and maybe linkes files what should I do then.
That's complicating problem for me and it sucks so much!!!!!!!!!!!!!1
That's complicating problem for me and it sucks so much!!!!!!!!!!!!!
Dec 20, 2010 01:19 AM|hemant.yadav|LINK
You can do. you simply need to allow remote access in mysql setting after allowing remote access to your mysql database from server you will able to connect live database on your local machine.