April 24, 2007 at 7:14 am
HI
I 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?
April 24, 2007 at 9:56 pm
It really depends on how many changes are made during the day to your system and what type of connection you have to the second server that the replicated data will be running on. If there are minimal changes - then I would use Transactional replication, where only the changes made will be replicated. If you have no concern for bandwidth issues and timing of the data transfer, you can use snapshop replication where an exact copy of the database is replicated every day.
You can use the wizard within Enterprise Manager to easily setup the Replication on the database you want to publish, and also on the database you wish to setup as the subscriber.
Catherine
Catherine Eibner
cybner.com.au
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply