SQL Server Performance

cube migration

Discussion in 'SQL Server 2005 Analysis Services' started by beaniebear, Dec 16, 2005.

  1. beaniebear New Member

    I have one cube on sql server 2000 analysis service. I want to migrate to sql server 2005? Is there anybody familiar how to do this?

    Thanks,
    - Kathy
  2. Luis Martin Moderator

    Did you migrate all database before?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. pawanreddi19 New Member

    Hi Luis ,

    I too have the same problem. i am unable to get my SQL Server 2000

    Cubes in to SQL SERVER 2005 . i able to get the databases of SQL Server

    2000 to 2005 but unable to get the cubes . can u help me out by suggesting

    some points to do the same .

    Thanks and Regards,
    Pavan.

    quote:Originally posted by LuisMartin

    Did you migrate all database before?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.




  4. ChrisFretwell New Member

    Pavan, what issues are you having with the 'getting the cubes'?

    We had a few cubes in 2k and were only able to move one of them using the migration wizard. The others we created new in 2k5.
    The problem we had refered to something about a duplicate column name or something like that (we migrated the day the RTM came out so it was long enough ago that I dont remember the specifics).

    In the end, this turned out to be a good thing. There were so many great advances and changes between 2k and 2k5 versions of AS that we were able to do more, faster and easier by creating our cubes new in 2k5 rather than just upgrading.

    Anyway, back to the original question - what errors were you getting that were stopping you from ugrading your cubes?
  5. heiner New Member

    Hi,
    i have the same problems.if i migrate the cubes,my data source is even the same like before(sql2000)-but i want to make my sql2005 server to datasource of my cubes too?
    how can i realize this?

    thanks
  6. ranjitjain New Member

Share This Page