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 |
|
ayamas
Aged Yak Warrior
552 Posts |
 Posted - 2006-06-17 : 00:53:40
|
| hi guys,I have a problem.A new project is under consideration in our company.The need of the client is that he will be having local databases at different locations.He wants that in the nightthe data from all the locations should be updated to the main database through dial up.The dial up will be scheduled using windows scheduler.I mean for one location the dial up will be running for 30 minutes & after tat it will disconnect & then reconnect to other location.All this things will happen in the night.What I want to know is how will the data be fetched from the tables of SQL server of that particular location & then inserted into the main location database only after the connection is up from the dial up.Any help is greately appreciatedThanks in advance |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
Is this possible?