sgreenwest
Programmer
Hi All,
I'm pretty new to all this stuff so please be nice. i have been handed the problem of designing and developing an on-line application system for our business. The application will be hosted by an external company and we will upload and download information to the company on a daily bias. What i want to now is how i go about updating SQL server on the ISP with new information i created each day on my local network. Also i want to pull down all new records created that day to a local copy of the Database(exact copy). From what i have read the DTS package is the tool to do this but I'm not sure how i do this when the databases i want to connect to is up on my ISP's Network. Ant tips hint's or links to tutorials would be great
I'm pretty new to all this stuff so please be nice. i have been handed the problem of designing and developing an on-line application system for our business. The application will be hosted by an external company and we will upload and download information to the company on a daily bias. What i want to now is how i go about updating SQL server on the ISP with new information i created each day on my local network. Also i want to pull down all new records created that day to a local copy of the Database(exact copy). From what i have read the DTS package is the tool to do this but I'm not sure how i do this when the databases i want to connect to is up on my ISP's Network. Ant tips hint's or links to tutorials would be great