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 |
|
ias0nas
Starting Member
36 Posts |
 Posted - 2011-03-23 : 10:42:52
|
| Hello,I have a scenario where there is a central SQL 2005 database that needs to store data coming from multiple clients.The data is entered into the client devices and need to be pushed to the central DB at some point.I was wondering what is the best way of doing that having in mind the database schema may need to change at some point and the fact I will have no control over the network configuration the clients are in. They may be behind firewalls or using public wi-fi networks.Would you consider replication as an option? Or is going to cause problems both with network configuration and when the database needs to be updated?SSIS?Any other options?Thanks,Jason |
|
|
|
|
|
Collect Data from Clients