Deploying Analysis Services 2000 without data

Hi there :-)

I want to deploy a complete Analysis Services database from our development server to the live server, but without archiving it and having to send a couple of gig in data!

I can't see anywhere in the Analysis Manager to just script the whole thing as i would with a SQL Server database?

The live server is on a different network maintained by a thrid party and it will be a real pain if we have to send the whole thing on disk every time we want to make a change. I am working from a local copy of the source SQL Server database.

I'm a bit of a newby so please forgive me if it's completely obvious and i have just missed it. All i want to do is get an empty copy of the whole thing with all it's (empty) cubes, change the connection to the true live source SQL Server database and then build the data there.

Please help!

Regards,

Richard

For AS2000, in Analysis Manager:

- copy-paste the database (that will only copy the object definitions, but not the data)

- archive the copy (there is a right click menu on the database item, a .cab file will be generated)

- restore on the other server (right click menu on the server item)

Adrian Dumitrascu

|||

Thanks Adrian

Wow! I had assumed the data was copied when you copy the database. This is perfect!

Thanks for the information!!

Richard