SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 Connection Server 2005 .net
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ddaurio
Starting Member

USA
5 Posts

Posted - 07/24/2009 :  13:40:59  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 07/25/2009 :  07:31:17  Show Profile  Reply with Quote
to transfer your data, backup and restore it and change your web.config file to point to the restored external db

if you are using app_data folder, simply upload and give it read and write permissions
Go to Top of Page

ddaurio
Starting Member

USA
5 Posts

Posted - 07/25/2009 :  10:55:03  Show Profile  Reply with Quote
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?
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 07/25/2009 :  11:58:32  Show Profile  Reply with Quote
yes, you should be able to connect.

else find another host
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000