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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-03-22 : 19:58:09
|
| i have 2 DB in 2 different servers.db1 and db2db1 gets 150k records every hour. db2 is like the backup of db1. db2 is used to retrieve records to create reports using reporting services.what is the best way to synchronize db2 with db1?is it to create a dts package and set up a job that runs every hour?off topic question.what kind of language does reporting services use to create the reports? |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-23 : 00:26:56
|
| Transactional replication...works fine in sql 2000 and sql 2005Database mirroring...only with sql 2005...Dts also should be fine and you can schedule every 30/60 minutes...MohammedU |
 |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-03-23 : 08:37:31
|
| thanks |
|
|
|
|
|
|
synchronize DB in real time