Migration of AS2000 cubes to AS2005.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Migration of AS2000 cubes to AS2005.

Migration of AS2000 cubes to AS2005.

Rate Topic

Display Mode

Topic Options

Author

Message

akhtarforu

Posted Monday, January 14, 2008 11:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 30, 2008 11:44 PM
Points: 3, Visits: 9

i have MOLAP cubes in AS2000 and i have deleted fact tables , how can i migrate my cubes from AS2000 to AS2005

Post #442590

mdaniel

Posted Tuesday, January 15, 2008 10:10 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 7:49 AM
Points: 1,487, Visits: 509

Unfortunately, you need the fact tables for the AS2005 cubes.

To migrate the cubes, you have two paths: create new cubes with BIDS or use the migration wizard.

If you use the migration wizard, it will create new cubes and dimensions with structures similar (but not equal) to AS2000 cubes, it cannot copy the data.

With both options, you will need to process the AS2005 cubes.

Post #443128

akhtarforu

Posted Tuesday, January 15, 2008 1:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 30, 2008 11:44 PM
Points: 3, Visits: 9

Thankyou for your reply, i am thinking to run AS SERVER 2005 Setup on AS Server 2000, may be it will update my existing AS2000 cubes to AS2005 cubes.

Post #443218

« Prev Topic | Next Topic »

Permissions