I am trying to get a cube from a client for testing my app against.
They sent me a cub file which I can open in Excell but how do I get it
into AS2005? Is there another way they should export it out? Sorry if
this is a simple problem. I am still trying to get into this 2005
stuff.

you can backup/restore
or
generate the script and apply the script on target server (into management
studio, right click the database then generate the script)
or
import the database in VS2005, compile (an asdatabase file is created), and
use the deployment wizard on the target server (or if you have created your
project in VS there is no need to import it from the server)

or my favorite way:

synchronize 2 instances or 2 servers (doesn't works on the same instance)
(again in the mgmt studio)
Usefull when you have dev and production servers or you use an instance to
process and when the process is other you deploy the processed database on
the prod server, or you have more then 1 server to deploy. you can easely
schedule the synchronization process. this way also keep the security setup
on the dest. server.

<gslim (AT) blizzardice (DOT) com> wrote