Re: Deployment of Analysis Services 2005 database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxx> wrote in message
news:u7rw4sRQGHA.5400@xxxxxxxxxxxxxxxxxxxxxxx
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_@xxxxxxxxxxxxxx> wrote in message
news:udaJ55uPGHA.3672@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> wrote in message
news:ep9eBktPGHA.5564@xxxxxxxxxxxxxxxxxxxxxxx
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.







.

Relevant Pages

  • Re: A User wants DBO on a production db
    ... database growth or backups. ... you could relax security until the application is officially ... > security of other databases on the same sever or other servers on the ... > network. ...
    (microsoft.public.sqlserver.security)
  • RE: Secure Network Design (DMZ, LAN, etc)
    ... the 2 nics in each server and a private network behind the servers with the ... there are a couple of solutions for getting access to the database. ... easiest is to add another NIC and connect it to your inside network. ...
    (Security-Basics)
  • Re: Deployment of Analysis Services 2005 database
    ... My servers are not on the same network. ... Studio project folder) to your server using the deployment tool. ... database is filled with production data, ...
    (microsoft.public.sqlserver.olap)
  • Re: DMZ design
    ... > access a database hosted on the private network. ... > there is no way to securely update information on the servers. ... You don't want *any* host in the DMZ to be able to establish connections ...
    (comp.security.firewalls)
  • Re: Dcidag errors
    ... Port blockage between servers ... Other sorts of networking issues (lack of connectivity between the points ... These errors are typically a result of a network connectivity issue of some ... > replicating this nc. ...
    (microsoft.public.windows.server.active_directory)