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-05-06 : 05:19:22
|
| I have one problem.In my project I have different databases at 3 diff locations.Whatever the transactions are done are done at the local database of that particular local location.What I want is I will add some windows schedule tasks which will connect to these locations through dial upin the night.As soon as it gets connected the particular job which will designed in the particular server should run & the data should be transferred from those databases to my main database on at a time.Can it be done through replication?If yes then how?Or is there some other way.It is some what like POS.Any help is greatly appreciated.Thanks in advanceRegards,ayamas |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-08 : 21:03:28
|
| yes you can do this by replicationsnapshot replication and you can either schedule this based on the windows task schedule or enable it when you've connected (better option)if it's only straight forward transfer of data, a better option with little resources is just to use dts or sproc which you can call once connection has been establishedHTH--------------------keeping it simple... |
 |
|
|
|
|
|
SQL server & Windows scheduled jobs