Re: Deployment of Analysis Services 2000 database

There is actually a much simpler way of doing this in AS2K.

1. Right Click your OLAP Database and hit 'Copy'.
2. Right click your server and hit 'Paste'.
a. What this does is copy/paste the skeleton of your entire OLAP
database without the data.

3. Make a backup of your new database and send it to the customer.
4. Have them restore the .CAB file on their server.
5. Open up the data source(s) and change to which server/database is
at the customer.
6. Have them re-process the newly restored OLAP database.

That's it. HTH.

V

Henrik Skak Pedersen wrote:
Hi again Bobby,

This looks really great. Thank you very much.

Cheers
Henrik.

"Bobby Henningsen" <bobhen@xxxxxxx> wrote in message
news:uTeEOLiPGHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
Look at this undocumented feature :

http://www.microsoft.com/downloads/details.aspx?FamilyID=8d9e7a70-eef4-44c3-a0c5-deece0f8b4b4&displaylang=en

Regards :)
Bobby Henningsen

"Henrik Skak Pedersen" <skak@xxxxxxxxxxxxxxxx> wrote in message
news:O8POLFiPGHA.1832@xxxxxxxxxxxxxxxxxxxxxxx
I am unfortunately not able to connect to the customer, we are selling the
solution to a lot of customers and I would like just to send them a file.

Yes I have seen the feature in 2005, that is whay I would like something
like it in 2000 :-)

So how does everybody actually distribute OLAP solutions?

Thanks
Henrik.

"Bobby Henningsen" <bobhen@xxxxxxx> wrote in message
news:Opg67AiPGHA.3100@xxxxxxxxxxxxxxxxxxxxxxx
Well,
actually I don't think it would be a problem to change the datasource
after a restore but of course you'll bring your data along if you use
MOLAP. If it is possible to connect to your customers server from your
local analysis manager then you could simply use copy and paste and the
modify your datasource and process your cube(s). But of course you want
some scripting tool, I guess. This is posssible in SSAS 2005, though.

Regards :)
Bobby Henningsen

"Henrik Skak Pedersen" <skak@xxxxxxxxxxxxxxxx> wrote in message
news:ODd$E7hPGHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
Hi Bobby,

Thanks for your reply.

I would actually like only to copy the database schema if possible.
Because the datasource is different at our customer site (the database
schema is of course the same).

Regards

Henrik.
"Bobby Henningsen" <bobhen@xxxxxxx> wrote in message
news:%23uL163hPGHA.1832@xxxxxxxxxxxxxxxxxxxxxxx
Do you mean your database setup or your server setup ? I guess all
your info for your database are saved when creating a backup of the
database. Then simply restore at your customers server. But of course
be aware that your datasources is correct if the location of your
relational datamart is different.

Regards :)
Bobby Henningsen


"Henrik Skak Pedersen" <skak@xxxxxxxxxxxxxxxx> wrote in message
news:OiSZSnhPGHA.344@xxxxxxxxxxxxxxxxxxxxxxx
How do I deploy an Analysis Services 2000 database setup to a
customer?

Thanks

Henrik













.

Relevant Pages

  • Re: Transaction processing advice
    ... screen on my server where the data are entered into the database. ... handles sending the emails to the customer and the seller. ... Sometimes it is worthwhile to wait a few seconds and retry the connection ...
    (comp.lang.php)
  • Re: performance in a large table
    ... true source of the problem is not that difficult these days. ... Server load but that doesn't mean you can't fix that. ... Our biggest customer has a 1.1 TB database and they are not ...
    (microsoft.public.sqlserver.clustering)
  • Re: A Quality Penetration Test
    ... I've once worked for a VAR that sold vulnerability scanning/discovery ... Advanced External Penetration Test that our team delivered to a customer. ... to use those unchecked variables to penetrate into our Customer's Web Server ... automatically dump the contents of the database when executed. ...
    (Pen-Test)
  • Re: performance in a large table
    ... Determining if the SAN is the bottleneck and the true source of the problem is not that difficult these days. ... Most SAN's are not properly configured for a high end SQL Server load but that doesn't mean you can't fix that. ... It really sounds to me like the database code or schema is simply not optimized for such a large db and that needs to be addressed first. ... Our biggest customer has a 1.1 TB database and they are not ...
    (microsoft.public.sqlserver.clustering)
  • Re: teaching a child - console or GUI
    ... written back in '95 based on Paradox, now I'm asked to do a new version. ... universe - the demanding and unpredictable database. ... > is fully capable of running without the server online... ... What if the customer has more than 65535 items in stock? ...
    (comp.lang.pascal.delphi.misc)
Loading