Best and Easiest way to move data from one Cache DB to another on different server

[Zulfiqar]

What is the best way to transfer data between different Cache
databases that reside on a different server. I am looking at this for
the purpose of reporting/analysis. Has anyone any experience in using
Ralph Kimballs methodology for developing a DW on a Cache database.
Please share your experiences.

Thank you.

Zulfiqar.

[Pmkadow]

Zulfiqar,

 

Perhaps the simplest way to move Globals is using Global Export/Import

 

From the Cache Cube -> System Management Portal -> Globals -> Export/Import.

 

Paul "Mike" Kadow

--
List: http://groups.google.com/group/intersystems-public-cache
Devcon: March 21 - 24, Orlando, Fl.

[Der_Meister]

M.b. you can copy the CACHE.dat file to other server and mount it using simple script.

2010/3/14 Zulfiqar <zulfiq...@hotmail.com>

--
List: http://groups.google.com/group/intersystems-public-cache
Devcon: March 21 - 24, Orlando, Fl.

--
Yours sincerely,
                      Der_Meister

[pete]

And then begin shadowing on the new server if your intent is to use
the new box for reporting.

On Mar 14, 10:32 am, Der_Meister <d...@heavysoft.ru> wrote:
> M.b. you can copy the CACHE.dat file to other server and mount it using
> simple script.
>

> 2010/3/14 Zulfiqar <zulfiqar_...@hotmail.com>

[ban]

u can shodow or ecp the database

[Gilbert]

Another method I have personally used is performing a daily
FullAllDatabase Cache level backup, move the created backup file to
your secondary server and restore it back. The best way of
accomplishing this step is to ensure your secondary server contains
EXACT file paths for your databases to make the restore pretty easy
and straightforward.

We have done this via scripts and it is all automated, also, this
method tests your backup integrity, which you should periodically
verify anyways.

Hope this is helpful to you.