dbTalk Databases Forums  

archiving AS2000 and restoring in AS2005?

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


Discuss archiving AS2000 and restoring in AS2005? in the microsoft.public.sqlserver.olap forum.



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

Default archiving AS2000 and restoring in AS2005? - 01-07-2006 , 01:36 PM






Hi,

for a project I need a copy the schemes / cubes of some multidimensional
enterprise databases from a server in my company to my local machine. They
are running on a SQL Server 2000, but I need to transfer it to my local
installation of SQL Server 2005. The underlying relational databases are
already on my own server.

I created an archive file (.CAB) of each Analysis Services database I need -
but I have no idea how to tell my SQL Server 2005 to read this compressed
file or the extracted version (contains olapdb.inf and olapdb.rep in the
root directory and some subdirs with files for each dimension, measure,
....).

Thanks a lot for every hint! :-)

Nikolas



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: archiving AS2000 and restoring in AS2005? - 01-07-2006 , 05:38 PM






its not possible.
backups from AS2000 cannot be restored in AS2005.

you have to upgrade your cubes using the ugrade utilities of AS2005.

"Nikolas Neuhaus" <nikolasneuhaus (AT) alice-dsl (DOT) de> wrote

Quote:
Hi,

for a project I need a copy the schemes / cubes of some multidimensional
enterprise databases from a server in my company to my local machine. They
are running on a SQL Server 2000, but I need to transfer it to my local
installation of SQL Server 2005. The underlying relational databases are
already on my own server.

I created an archive file (.CAB) of each Analysis Services database I
need - but I have no idea how to tell my SQL Server 2005 to read this
compressed file or the extracted version (contains olapdb.inf and
olapdb.rep in the root directory and some subdirs with files for each
dimension, measure, ...).

Thanks a lot for every hint! :-)

Nikolas




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.