Replicating a copy of an AS2000 database

Last Post 23 Feb 2006 07:21 AM by roubicek1. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ShreuderM
New Member
New Member

--
10 Jan 2006 05:44 AM
Hi

We currently have a DW with a whole bunch of cubes. We have ProClarity on top for reporting with the users on another continent using a WAN connection to retrieve the data. The problem is that this connection can be quite slow and this is impacting on their ability to extract the data. They have therefore decided, that they require a local copy of the cubes to work with. Now, I would not like to duplicate the Whole DW and all the data load procedures, but would like to look at a method of just replicating the Cubes so that all new updates will be reflected on their side.

As far as I know, AS 2000 doeas not have anything like this, neither does AS2005(?). One suggestion has been to look at a disk mirroring application to transport the data across the WAN and update the disk on the otherside.

Has anyone done something like this before and can give me some suggestions?
Many Thanks
Michael
roubicek1
New Member
New Member

--
23 Feb 2006 07:21 AM
One method that has worked very well is the backup and restore copies of the databases to various locations. Though this is very primitive, in a MOLAP environment this works rather well. Of course, space, size, security, and time considersations are all in play here, but if you can work with the downsides, we have found it to be very reliable for subscribers of "published" AS databases.

Another approach would be to use ROLAP and replicate your relational data using SQL Replication. AS2005 has some really cool features like event driven notification when new data arrives which can then spark updates of aggregations on your subscriber side.

-Ben


Acceptable Use Policy
---