Hi Guys

I want to move my SQL Server and OLAP (same machine) to another one, it's
a infrastructure migration, so everything will be the same.

Installing both software (SQL Server and OLAP) and replacing DATA and
OLAPDATA folders will do?

I know that on SQL works but i have no experience on moving OLAP server.

Please post ur comments, its urgent !!!

Thanks in Advance
Razor

Migration from development server to production server is needed and two
strategies can be considered.

1. Using Archive and restore : migrate both of data and metadata
2. Using Copy and paste : migrate only metadata. it needs processing again.

Whatever you select, you need to modify the data source information to meet
production environment.

For more information on how to, refer to "Archiving, Restoring, and Copying
Data" from BOL and its sub titles.


Ohjoo Kwon


"razormx" <razormx (AT) urmama (DOT) com> wrote

Thanks for ur response, Can u be more specific?

My Scenario is have a SQL Server 2000 SP3 and Analysis Services SP3

I got a brand new server , more powerfull so i want to move everything to
the new server, it will have the same name, same domain ..

on SQL 2000 when i move to another server, i only need to copy the DATA
folder and replace it on the new server, so i got the same master
database.

How can i achieve that with OLAP ? I will install everything on the same
path, actually i will use the same disk (SAN)..... i Was thinking on
just moving the OLAPDATA folder and replace it ... will work ?



"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote in
news:eskf07nHFHA.4060 (AT) TK2MSFTNGP14 (DOT) phx.gbl:

Also discussed extensively in the Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx

--
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.

"razormx" <razormx (AT) urmama (DOT) com> wrote

Very interesting idea!!

Long time ago, I tried the similar scenario and it worked well. But it must
be done on your own responsibility.

Below was my scenario...

1. Register both production and development server.
2. Copy database on development server.
3. Paste it onto the production server.
4. Stop both Analysis Servers.
5. Copy data folder of development server onto the production server.
6. Start Analysis Server.

Here step 1, 2, 3 are to create the same meta data in the repository. I'm
not sure just copying repository db(msmdrep.mdb) substitute for those steps
but I believe you can test it easily.

Ohjoo Kwon



"razormx" <razormx (AT) urmama (DOT) com> wrote