Am I doing this the best way? 
Author Message
 Am I doing this the best way?

Hi

I 'm currently developing an Analysis server warehouse.  I have a PRODUCTION
and a DEV database (actually two different servers).  I have five cubes
linked to one virtual cube

When I'm ready to roll a new version of the warehouse to production here are
the steps I follow, is their an easier way?

.  Copy PRODUCTION database
.  Paste to OLDPRODUCTION database
.  Delete PRODUCTION database
.  Copy DEV database
.  Paste to PRODUCTION database
.  Design aggregations on PRODUCTION for one partition - one cube
.  Use partition manager to copy aggregations to every partition on every
cube (total of 15 times!)
.  Process PRODUCTION database

Is this the quickest way?    Doing it this method means I lose any
aggregations caused by USAGE BASED OPTIMIZATION, anyway to keep those?

Thanks



Tue, 25 Oct 2005 02:59:13 GMT
 Am I doing this the best way?

Hi Paul!

If I understand, you have two OLAP databases, one developing and the other
production databases. You need make update of your production database (by a
dev database) and do that as easy as it's possible. There is two ways (which
I know) how to ho that.

The first way is use "backup an restore":
1.) make archive of your dev database
2.) make archive of the production database - just in case
3.) delete your production database
4.) restore a developing database as the production
5.) check name of SQL servra in OLAP database source (let's assume that you
use an SQL server as data source)
6.) process the production database and that's all

Watch out! This way assume that the name of dev and production databases are
the same! Thus way is great if your developing database is on your dev
server (e.g. in your office) and production database on your customer's
server. I use this way.

The other is use "Meta data scripter":
First of all I have to say that I never use this way! ;-) But I want.
1.) you have to install meta data scripting add-on to your Analysis Manager
(it's on SQL Srv 2000 resource kid CD)
2.) click the right mouse button on your dev database, from "All Tasks"
select "Create meta data script" - it generate VBS script
3.) backup your production database - just in case
4.) maybe it will be better if you drop the production database
5.) run the VBS script on your procudtion server
6.) process the "new" production database

There's a "snag" as in the first as in this way. You'll need Visual Basic 6
to compile this add-on, and SQL Resource Kit too, of course. However, the
first way is directly implemented in Analysis Manager. But only in SQL
Server 2000 Analysis Services (OLAP v8).

I hope that at least one way helps you.

Have a nice day

Vlado


Quote:
> Hi

> I 'm currently developing an Analysis server warehouse.  I have a
PRODUCTION
> and a DEV database (actually two different servers).  I have five cubes
> linked to one virtual cube

> When I'm ready to roll a new version of the warehouse to production here
are
> the steps I follow, is their an easier way?

> .  Copy PRODUCTION database
> .  Paste to OLDPRODUCTION database
> .  Delete PRODUCTION database
> .  Copy DEV database
> .  Paste to PRODUCTION database
> .  Design aggregations on PRODUCTION for one partition - one cube
> .  Use partition manager to copy aggregations to every partition on every
> cube (total of 15 times!)
> .  Process PRODUCTION database

> Is this the quickest way?    Doing it this method means I lose any
> aggregations caused by USAGE BASED OPTIMIZATION, anyway to keep those?

> Thanks



Fri, 28 Oct 2005 16:24:08 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. other ways of doing a query

2. Better ways to talk than DB-lib

3. Best ways to store Text of indeterminate length

4. Please give opinions on different ways to setup disks for best performance under SQL

5. Batch insertion from .net, better ways?

6. Best ways of Debugging a Stored Proc...

7. dropdownlists and grids, which ways is the best?

8. good ways to use recordsets without autocommit?

9. getNumResultCols, any better ways?

10. RFI - Best ways to sync data across platforms

11. RFI - Best ways to sync data across platforms

12. Any better ways to manage programs?


 
Powered by phpBB® Forum Software