The only way is you have to logon to the webserver/if UI provided by host company to have access of DB, Take backup, if you take backup using UI then it will copy directly onto your local computer otherwise you have to have FTP Access to download DB backup
from webserver and restore into the local machine.
If you are tachnical support team then you must have access of webserver or know host UI. Or contact to the company who hosted website.
Maybe you can create a web application that get all data from database and send it inside a textfile... or something like this. The others comments are right, your hosting service must be able to create a database backup.
mariam_louis
0 Points
5 Posts
connect to local sql sever database from website on webserver
Dec 13, 2012 08:00 PM|LINK
I have database on webserver
I need to transfer data from this database to local database
what is the best way to implement this task
1. develop desktop application & connect to database on server
2- make website ? but how to connect to localdatabase
Please advice
HostingASPNe...
All-Star
15882 Points
2977 Posts
Re: connect to local sql sever database from website on webserver
Dec 13, 2012 08:12 PM|LINK
Hello,
You can make a backup on the server and after that restore it on the local PC.
Regards
Free ASP.NET Examples and source code.
mariam_louis
0 Points
5 Posts
Re: connect to local sql sever database from website on webserver
Dec 13, 2012 08:28 PM|LINK
Thanks for your help
the task will be done on customer location by our support so i need quick & practical way
thanks
mariam_louis
0 Points
5 Posts
Re: connect to local sql sever database from website on webserver
Dec 13, 2012 09:44 PM|LINK
I need solution
please help
pratiksolank...
Member
271 Points
76 Posts
Re: connect to local sql sever database from website on webserver
Dec 14, 2012 01:18 AM|LINK
Hi,
The only way is you have to logon to the webserver/if UI provided by host company to have access of DB, Take backup, if you take backup using UI then it will copy directly onto your local computer otherwise you have to have FTP Access to download DB backup from webserver and restore into the local machine.
If you are tachnical support team then you must have access of webserver or know host UI. Or contact to the company who hosted website.
Regards
Pratik
mariam_louis
0 Points
5 Posts
Re: connect to local sql sever database from website on webserver
Dec 16, 2012 05:18 PM|LINK
Hi
My Manager refuse DB to be on local machines as it contain important data
if local machine has static ip i can log in from web server & transfer Data
also can i use pc virtual ip
thanks
radamanthys
Member
228 Points
74 Posts
Re: connect to local sql sever database from website on webserver
Dec 17, 2012 10:02 PM|LINK
Maybe you can create a web application that get all data from database and send it inside a textfile... or something like this. The others comments are right, your hosting service must be able to create a database backup.