dbTalk Databases Forums  

How to Migrate an OLAP Cube (32 bits Server) to a 64 bits Server Itanium 2 ?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to Migrate an OLAP Cube (32 bits Server) to a 64 bits Server Itanium 2 ? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PCL
 
Posts: n/a

Default How to Migrate an OLAP Cube (32 bits Server) to a 64 bits Server Itanium 2 ? - 12-20-2004 , 04:05 AM






Hello,

We want to migrate a cube (.CAB > 2GB) on a 64 Bits Analysis Services.
Is this possible by copying the files ?...

Thanks.

Pascal



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: How to Migrate an OLAP Cube (32 bits Server) to a 64 bits Server Itanium 2 ? - 12-20-2004 , 11:33 PM






Yup. Or rather archive the database; and then restore it on 64-bit.
Or if you *really* want to (or need to) do it via file copying, then first
migrate your OLAP repository to a dedicated SQL Server database (same
server; servername=localhost or "."); then stop the msmdsrv service on both
sides (which keeps everything quiet while you are copying), copy your data
folder, copy your olap repository .mdf file, attach the relational OLAP
repostitory on the 64-bit server -- and restart the msmdsrv service.

The file formats (both relationally and AS) are exactly the same format on
both hardware architectures. Cool huh.. :-)
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"PCL" <jb (AT) caramail (DOT) com> wrote

Quote:
Hello,

We want to migrate a cube (.CAB > 2GB) on a 64 Bits Analysis Services.
Is this possible by copying the files ?...

Thanks.

Pascal





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.