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 |
|
zillur29
Starting Member
1 Post |
 Posted - 2009-03-05 : 11:51:49
|
| Hi AllI like to integrate database for two location (Same database). One database is active and other one is only for view report(Management Use). Every day i have to send data from 1st location to second. It is difficult to send entire database. How i can send daily data according daily transection. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-05 : 13:15:07
|
| Look at Transactional Replication. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-05 : 13:25:37
|
| is it a one time transfer? if thats the case, what you can do is make some ssis packages which transfers data from active to view report databse as nightly job and write logic to take only changed data |
|
|
|
|
|
|
Periodic Data for sql server 2000