Importing SQL 2000 data into 2005

Hello!

I've got some backuped files from a 2000-server Analysis services and I need to import them into 2005. The problem is that I am not sure how these files where made and thus what they are. AFAIK they are simple dumps of databases. At least they have the same names:

msdb_db_<date>.bak (500Mb)

model_db_<date>.bak (800Kb)

and the actual database with data which doesn't have a file-ending at all.

These files are used as backup and apparantly it is possible to restore the 2000-server using them. Basicly this is all I know about these files. Is there any way I can do this? The background to this story is that I am trying to setup a testing 2005 server without touching the running 2000 server. Any other way I can do that?

Thanks!

I've moved the thread to the Analysis Services forum, where you should get an answer.|||

You cannot restore Analysis Services 2000 backup files directly with Analysis Services 2005. Instead you need to resore them on AS2000 and then run MigrationWizard.exe to transfer the databases to AS2005 (or to generate a migration script that you can later run on AS2005).

You can invoke MigrationWizard.exe from SQL Management Studio, right click on the AS2005 item and use 'Migrate Database ...' option). Or directly from %ProgramFiles%.

Adrian Dumitrascu

|||

I see, I'll try that. Thank you!

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?

Importing data from Movex

I am looking to replicate data from a Movex system into an SQL 2005

database for reporting and analysis purposes. Does anyone have any

ideas/tips on how to go about automating this process? With scripts?

Thanks in advance.

Dan E.

You may try your question at the MSDN forum: SQL Server Reporting Services (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1).

|||
Thanks.

Importing cube using XMLA

Hi,

We're trying to import cubes from SASS 2005 into Oracle BI EE (Siebel Analytics) using XMLA.

I tried to use SDK for Analysis 1.1 with the file msxisapi.dll but it uses msolap.asp on the AS server and I don't get any response from it (written in log).

In this forum I got a reply to use msmdpump.dll in order to create http access to SASS but it won't work with Siebel (shows empty list of databases) becaues I must use XMLA protocol.

Moreover, I don't think it's a security issue because I had managed to access the cube via Excel.

I will be graeful to gain some help.

> In this forum I got a reply to use msmdpump.dll in order to create http access to SASS but it won't work with Siebel (shows empty list of databases) becaues I must use XMLA protocol.

AS2005 aways uses XMLA protocol when you connect over HTTP (i.e. through msmdpump.dll). You may want to pursue this issue with Oracle (Siebel) to understand why you are getting empty list of databases.

|||Hi. I'm experience the same problem that you described, do you any solution?
Thanks.
mreyes@.itsolutions.com.gt