December 18, 2002 at 10:18 am
Is there a best practice for transfering info from a production box to a reporting box say every 30 minutes or so. I was depending on log shipping to do this but stupidly forgot that exclusive access would be needed and users will be attached to the reporting db. SQL Replication is not supported by our software vendor so this out also. Hands are tied and running out of option. Any help would be greatly appreciated
December 18, 2002 at 10:52 am
Backup / restore or some custom/complex/DTS packages. No other real way.
Steve Jones
December 18, 2002 at 11:52 am
Before the advent of DTS or replication, we used scheduled stored procedures on each end. Keep in mind that replication is essentially just that.
Another method might be a third party replication (yuck!), as most vendor's who do not support SQL replication, have no issue with some of these. The one I use in this situation is Datamirror, and though we have a few issues with it, it performs well.
Another option might be Linked servers and differential updates using stored procs, again scheduled.
None of these are Best practices, but they all work, and provide much more flexibility than Replication or Log shipping, and depending on how they are implemented, can be less management overhead.
Edited by - scorpion_66 on 12/18/2002 11:53:38 AM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply