What is best practice when I have to deploy an Analysis Services 2005
database schema?
1) Is it to script it (Right click, Generate create script) ?
2) Backup/restore?
3) Can I do it from Visual Studio?

I only want to deploy the schema. I have to deploy it to multiple customers
and I don't have access to their servers. I might also have to ship updates.

Thanks

Henrik Skak Pedersen.

from VS:
change the deployment target server, and deploy the solution.

from the management studio:
you can create script, backup / restore (contain the data) or synchronize
the database (its like doing a backup / restore but in 1 command which can
be scheduled)

also, you can simply deploy the database file (found under the Visual Studio
project folder) to your server using the deployment tool.

what is the best way?
if your servers are not on the same network, use the deployment tool and do
a full process.
if your servers are on the same network and if your source version of your
database is filled with production data (not a subset of data), then use the
synchronization option. (no full process required)
if you want to deploy part of your database or you want to update ome parts
but not all the database on the target server, create an XML script.

"Henrik Skak Pedersen" <skak (AT) community (DOT) nospam> wrote

Thank you very much for your reply.

My servers are not on the same network. Which deployment tool are you
referring to? Do you have any examples of how to do it?

Thanks
Henrik.

My servers are not on the same network
"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

all these tools are included in AS2005
under the start > programs you 'll found everything (if you have installed
the administration tools on the computer)

"Henrik Skak Pedersen" <skak (AT) community (DOT) nospam> wrote