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:52:59
|
| 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 |
|
|
arshadkhwaja
Starting Member
5 Posts |
Posted - 2006-06-18 : 06:37:37
|
| Yes you can do but need to have some additional tables that contain which information of which tables are to be copied.If u use front end to connect the databases will be simple to write procedures which will scan the additional tables that contain information which is to be copied and by making loop of EOF you can one by one table..... you need some hard core programming...You can mail me if you need more info |
 |
|
|
|
|
|
Is this possible?