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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-06-10 : 05:20:44
|
| I have Server1,server2( local servers)these severs are in network server1 is the live server(database and application)server2 is the local database serverEnd users useing application enter data into(server2),here lote of Transactions going everydayI need to load data from server2(Local DB Server) to server1 Periodically in daily or hourly basis. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-10 : 05:23:39
|
| You can use DTS Export/Import wizard to create a package for data transfer. Add a new sql job to execute this dts package and schedule it to happen periodically. |
 |
|
|
|
|
|
How load data from one server to another server