AS 2005 Copy Cube (not sure if i''ve posted twice)

Question

AS 2005 Copy Cube (not sure if i''ve posted twice)

wildh

SSCarpal Tunnel

Points: 4370
More actions
February 3, 2006 at 7:59 am

#168064

How do you copy and paste an AS 2005 cube from one database to another.
Copy and pase is a great AS 2000 functionality that allows us to quickly make copies and test changes. Can we do the same in 2005? if so how? if not why the heck not?
N.B I'm using the microsoft freebie "SQL Server 2005 - personal edition".
February 6, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

I'm using Dev edition so it could be different, but if I have two AS projects open, I can right click on a cube (in the cubes folder) in Project1, select COpy and then right click on the cubes folder in Project2 and select Paste. A quick test shows that it doesn't take everything else like it used to (eg dsv and datasources and dims need to be manualy copied over also) but it definitely does take the cube

Steve.

wildh SSCarpal Tunnel Points: 4370 More actions · Answer 2

Steve,

Thanks for the feedback. I'd managed to do the same in Management Studio via "right click" and "Script Cube as". Unfortunately with the same results (no views, security, data source etc).

Is it the way that I develop (copy, paste, make changes, test changes, apply changes to live, delete dev) that is incorrect, or is it just a humongous oversight in functionality by Microsoft.

To be honest, for me "copy/paste cube" in 2000 was a killer function and I would have thought it would be essential in 2005.

I’m now left with the question - How do I quickly make a copy of a cube and all its associated objects (dims, security etc) so I can keep development time down to a minimum?

If anyone knows I’d be very grateful.

Howard.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

Well, there is always copy|paste of the entire project, but do it via Windows Explorer rather than in the UI. As every file in the entire proj is an xml file these days, a straight file system Copy|Paste and then open the "new" project in the UI again. You'll need to rename it (the proj, or at least the DB) before deploying to ensure that the DB name is different when deployed to the server.

Steve.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 4

OK, lots of options here, I typed heaps before but now will do it in point form:

1. Create/add a new project, make it 'Import AS DB' type project, import one of your deployed DB's you get all the bits (DS's, cubes, dims etc) and then you can deploy as same name (ie over-write) or new DB (dev)

2. use two servers (or use named instances on your machine), set your dev deployment option to dev server, your prod deployment option to prod server. this way you can muck around in dev, get it right, then change project 'mode' to be production and voila, it deploys all of your new great work to the prod environment. (look for the 'show me the impact of my changes feature, i haven't tested this but am interested to see what it tells you).

Cheers,

Steve.