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.

 All Forums
 Development Tools
 ASP.NET
 some advice

Author  Topic 

Chainy
Starting Member

1 Post

Posted - 2010-12-03 : 16:51:29
I'm looking for some advise on how I could solve the problem I face, I have various instances of sqlexpress 2005 in different remote locations which are not accessible via internet vpn etc as they are all in corporate networks that will not allow access. What I think I need to do is create some sort of process/service that can be installed on the client and run at a set time/date that collects all the data from theses instances and then push the changes to our remote instance of sql server. Can anyone possibly point me in the right direction of various technologies I should be looking into to solve this problem. All clients would be running windows XP. I have been searching for a few day's but I can't find anything to get me going. If this is not the right forum for this type of question can you suggest any?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-03 : 17:17:46
Well what will those networks allow? FTP?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2010-12-04 : 08:53:19
Without internet ??? That means no communication ???

Although it doesnt work for express edition.

look into this

Replication
http://www.sql-tutorial.net/sql-replication.asp

SSIS
Go to Top of Page
   

- Advertisement -