Post reply

replicate sql 2000 cube to sql 2005

  • May 6, 2008 at 7:48 am

    #207108

    how can I copy a sql 2000 cube to sql2005? thanks

  • May 6, 2008 at 10:14 pm

    #811555

    use VS 2005 to create a new import Analysis Services 9.0 db and choose the source as ur 2000 cube then deploy the same to the 2005 cube.

    or right click ur SSAS server instance in object explorer and ur should see migrate database ...

    Personally i prefer the first option...

    cheers

    Jayanth Kurup[/url]

  • May 7, 2008 at 8:05 am

    #811806

    well if I migrate does that destroy my source cube or does the source cube and environment remain intact?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply