Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ddaurio
Starting Member
5 Posts |
 Posted - 2009-07-24 : 13:40:59
|
| I am developing a web site application that I had hoped to host on an external site. So, I thought I would write a little test application to see if I could create the tables and access them. I could access the sql server hosted on the external site. My question is: When I run the site from the hosted site, should I be able to also connect to my local sql server? I was thinking I would be able to have a connection to both and transfer data. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-25 : 07:31:17
|
| to transfer your data, backup and restore it and change your web.config file to point to the restored external dbif you are using app_data folder, simply upload and give it read and write permissions |
 |
|
|
ddaurio
Starting Member
5 Posts |
Posted - 2009-07-25 : 10:55:03
|
| My hosting service only lets you restore databases backed up on their system.Should I be able to connect to both servers? Or is that a security thing? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-25 : 11:58:32
|
| yes, you should be able to connect. else find another host |
|
|
|
|
|
|
Connection Server 2005 .net