Importing Database from Analysis Services 2005 to SQL Server 2005 database

Hi all,

How can I Import a database from Analysis Services database to SQL SERVER using SQL SERVER 2005.

forexample the Adventure Works DW database from Analysis Services to SQL SERVER database.

Any ideas will be higly appreciated.

Thanx

this link might help: http://msdn2.microsoft.com/en-us/library/ms143278.aspx|||

That Link does not help. Once again I need to migrate a database from Analysis Services 2005 to SQL SERVER database.2005.

|||

Ronaldlee Ejalu wrote:

That Link does not help. Once again I need to migrate a database from Analysis Services 2005 to SQL SERVER database.2005.

if i'm not mistaken, the as 2005 cube should've been created from a sql server 2005 db. does the original sql server 2005 db no longer exist?