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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2007-04-24 : 09:09:32
|
| HII want to update my database everyday for just reporting purpose from the original database. I was thinking of replication to use for this but not sure wht type of replication best fits into. My real purpose is to duplicate the original database at my end for reporting purpose and am not going change anything on my database.Pls let me know wht is the best i can do for this or can i just perform this through a DTS? |
|
|
sshelper
Posting Yak Master
216 Posts |
Posted - 2007-04-24 : 09:31:27
|
| You have 2 options, either you use a snapshot replication or a transactional replication. If your database is not that big, you can do a snapshot replication, which will replicate your whole database. If your database is big and you do a lot of transactions a day, then you go with the transactional replication.SQL Server Helperhttp://www.sql-server-helper.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 10:00:24
|
| DTS works well for small db. |
|
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2007-04-25 : 09:51:30
|
| rmiaoyeah but DTS may not migrate sp's,views etc.. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-25 : 10:26:34
|
| Yes it does, just choose transfer db objects. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-25 : 13:05:28
|
| If it is just a daily update rather than ongoing, then I would just use backup/restore.We use transactional replication for our reporting environment because it requires up to date information. If we could get away with old data (24 hours old for example), I'd definitely switch to backup/restore.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Replication type