Migrating From Development to Production Environment in MSAS 2005

Hi,

I have built a project in Ananlysis Services 2005 and would like to migrate the contents of the Project ( Dimensions, Measures, Cubes Etc) to a New server having analysis Services 2005 , what is the best approach. Does microsoft provide any best practices document. I searched the forum and the topics on migration seem to be from Analysis Services 2000 to Analysis Services 2005, can some one guide me on migration between Analysis Services 2005 and 2005.

Thansks

A backup and restore (like in AS2000) is certainly possible. This is the only method if you need to get the data cube moved in a processed state (with data). Except you could use the new synchronization feature, but that would probably be using this feature for something it was not quite intended.

The recommended method would be using the new AS Deployment Wizard. Make a "build" in BI Development Studio of your database and fire up the AS Deployment Wizard. This will allow you to specify different settings for your cube database when it is deployed to the production server. For more info on how to use the Deployment Wizard, see http://msdn2.microsoft.com/en-US/library/ms176121.aspx

Migrating cubes from SQL Server Analysis Services 2000 to MS SSAS 2005

Hello

I am fairly new to SQL Server and wanted to know the best way of converting a .CAB cube created in SSAS 2000 to SSAS 2005 and then associate it with a database.

Rgds

Ankur

Backups done in AS2000 cannot be restored in AS2005. Your best course of actions is to restore the .cab backup on AS2000 system, and then migrate it to AS2005 system.

Migrating AS2000 to AS2005 on two seperate machines

Hi champs!

I have two seperates machines, one SQL2000 with some Cubes, and one with sql2005 and AS 2005.

I've tried the migrate wizard, but the sql2005 machines cannot connect to the sql2000 machine through OLAP connection.

The two machines ar in the same workgroup, but not in a domain.

Do I have to make a linked server connection? and if so how exactly is the syntax for connecting to a 2000 OLAP cubes?

I've tried to install AS2000 on my sql2005 machine, but that will not work.

I cannot restore AS2000 cubes on the AS2005 either.

/Many thanks

For one, to be able to install AS2000 on AS2005 machine you need to make sure you are running Analysis Server as named instance.

You can ether reinstall AS2005 and choose it to be named instance or use ASInstanceRename utility to rename defult instance. After that you should be able to install AS2000.

As for not being able to migrate from remote machine, if you choose to go that way. Try first installing AS2000 tools- Analysis Manager and use and work out through process of being able to use that to remotely access AS2000 server. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Migrating AS2000 to AS2005 on two seperate machines

Hi champs!

I have two seperates machines, one SQL2000 with some Cubes, and one with sql2005 and AS 2005.

I've tried the migrate wizard, but the sql2005 machines cannot connect to the sql2000 machine through OLAP connection.

The two machines ar in the same workgroup, but not in a domain.

Do I have to make a linked server connection? and if so how exactly is the syntax for connecting to a 2000 OLAP cubes?

I've tried to install AS2000 on my sql2005 machine, but that will not work.

I cannot restore AS2000 cubes on the AS2005 either.

/Many thanks

For one, to be able to install AS2000 on AS2005 machine you need to make sure you are running Analysis Server as named instance.

You can ether reinstall AS2005 and choose it to be named instance or use ASInstanceRename utility to rename defult instance. After that you should be able to install AS2000.

As for not being able to migrate from remote machine, if you choose to go that way. Try first installing AS2000 tools- Analysis Manager and use and work out through process of being able to use that to remotely access AS2000 server. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Migrating Analysis Services Roles

Hi,
I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is possible.
Thanks!
Look at the Release Management section in the AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
Dave Wickert [MSFT]
dwickert@.online.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.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:7204F1A0-8FA6-47BB-8023-FB18D845CAF0@.microsoft.com...
> Hi,
> I have an Analysis Services database that contains 5 cubes. Is it possible
> to migrate the database and cube roles from a development machine to a
> production machine by performing a file copy? If so, exactly what has to
> copied. If not, what is the best way to do it if it is possible.
> Thanks!
sql

Migrating Analysis Services Roles

Hi,
I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is possible.
Thanks!Look at the Release Management section in the AS Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@.online.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.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:7204F1A0-8FA6-47BB-8023-FB18D845CAF0@.microsoft.com...
> Hi,
> I have an Analysis Services database that contains 5 cubes. Is it possible
> to migrate the database and cube roles from a development machine to a
> production machine by performing a file copy? If so, exactly what has to
> copied. If not, what is the best way to do it if it is possible.
> Thanks!