Deployment Copy/Paste Problems

Hi all,
We maintain our CAB (meta-data only) in a source control system. The
process for deployment is simply to restore the CAB on the production
server and then copy/paste it to the production database name where it
will have it's final resting place.
By doing this we allow for scalability and robust management since the
same CAB can be deployed to many places. (In some places we process
different sets of cubes than in other places but the same meta-data
can be re-used.)
The problem we are finding is that one of our production servers is a
64 bit box that is (necessarily) remotely managed from a 32 bit
instance of Analysis Manager. When copy/pasting the database remotely
it takes a very, very long time to complete. Keep in mind that only
meta-data is being copied. When copy/paste is happening, it looks
like DSO code is executing to rebuild an entire database from scratch.
Does anybody have a faster method of copy/pasting an Analysis Services
database into place for deployment purposes?
Thanks,
DavidDavid Beavon wrote:

> Hi all,
>
> We maintain our CAB (meta-data only) in a source control system. The
> process for deployment is simply to restore the CAB on the production
> server and then copy/paste it to the production database name where it
> will have it's final resting place.
> By doing this we allow for scalability and robust management since the
> same CAB can be deployed to many places. (In some places we process
> different sets of cubes than in other places but the same meta-data
> can be re-used.)
>
> The problem we are finding is that one of our production servers is a
> 64 bit box that is (necessarily) remotely managed from a 32 bit
> instance of Analysis Manager. When copy/pasting the database remotely
> it takes a very, very long time to complete. Keep in mind that only
> meta-data is being copied. When copy/paste is happening, it looks
> like DSO code is executing to rebuild an entire database from scratch.
>
> Does anybody have a faster method of copy/pasting an Analysis Services
> database into place for deployment purposes?
> Thanks,
> David
http://www.solgenia.com/usa/Solutio.../SheetRubik.htm