June 25, 2003 at 8:01 am
We are trying to define the roles and responsibilities for deploying Analysis Services. What is a good migration strategy for moving it to production? Who should manage/support it in production if it is on the same server as the databases? If it is on a separate server than where the databases reside, who should manage/support these cubes?
July 1, 2003 at 7:17 am
Hey BABs,
As far as migrating from DEV to PROD, there's a few options. You could archive the database on the dev server, and then restore it to the Prod server. This works well, but something that really annoys me is that you can't rename your data source after doing this, so if your machines are named like some of ours (e.g. ABCDEV001) you end with a data source in PROD with a name that looks like it's refering to the dev datasource.
If you can see/manage both servers from your AS management console, you could just copy and paste items from server:catalog1 to server2:catalog1.
Management of the AS server and catalogs/cubes should probably fall under whoever is managing your EDW (I guess thats an assumptionthat you have one). In the case that you don't have a warehouse team, you will want to assign it to someone who will actually take some time on it. Dependant on your cube design (which is driven somewhat by your data sources), your cubes may not be overly self-reliant. For e.g. if you have partitions, one for each year of data, at some point you'll need to roll into the next/new partition as a year end comes around. Again, it's design dependant but there's quite a few things like that that need some level of monitoring/management.
HTH,
Steve
Steve.
July 1, 2003 at 7:52 am
THANK YOU....I actually am the DBA but have not had any hands on the Analysis Services and I welcome any information. Thanks again.
BABs
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply