Essbase Data Migration
Hi,
We have two identical Essbase databases and the aim is to extract all data from one and import it to the other, so that both databases contain the same data. We've tried this using maxl but as the database is 36GB even the export takes too long on its own (8hours+). We've tried exporting to multiple files but the time is still not acceptable.
Is there a quicker way to do this since the outlines are exactly the same? Is it possible to copy the .pag and .ind files, or is there a way to synch the data directly between the apps? The apps are hosted on different Essbase servers and we need to be able to automate the process so can't use EAS.
We have two identical Essbase databases and the aim is to extract all data from one and import it to the other, so that both databases contain the same data. We've tried this using maxl but as the database is 36GB even the export takes too long on its own (8hours+). We've tried exporting to multiple files but the time is still not acceptable.
Is there a quicker way to do this since the outlines are exactly the same? Is it possible to copy the .pag and .ind files, or is there a way to synch the data directly between the apps? The apps are hosted on different Essbase servers and we need to be able to automate the process so can't use EAS.
0