Hi,

I know its not the first time you see this question.
But I've not found the answer...

how to copy a cube from 1 database to another?
I've 2 databases on the same server "development" and "Production"
when my developped cubed are approved, then I want to copy these cubes.

I don't want to destroy / recreate the target database, just copying the new
cube.

any guide or tool?

I test the DSO/xml tool, but its a long process.

thanks for your help.

Jerome.

Hi Jéjé,

You only should need to edit the source at Data Sources and then
Refresh it (right click at Database Name). All of cubes & dimensions
will be changed.

Hi Jéjé,

Sorry, it seem I've misunderstood your question ...
You want to "copy" it not "move" it, right? If you do, you can archive
all of the database by right clicking at Database Name, give alias name
for CAB files that is generated. After complete, you can restore it by
right clicking the Server Name.
Good luck!

well... I've added in my requirements:
I don't want to replace my existing database !
only adding the new cube.

the archive/restore process destroy anything.

I've found the metadatascripter in the ressource kit
But I've not VB6, only .NET and the convertion appear to not work correctly!

anyone can send to me a compiled version of this tool?

"Resant" <resant_v (AT) yahoo (DOT) com> a écrit dans le message de news:
1102992965.271220.206600 (AT) z14g20...oglegroups.com...
Hi Jéjé,

Sorry, it seem I've misunderstood your question ...
You want to "copy" it not "move" it, right? If you do, you can archive
all of the database by right clicking at Database Name, give alias name
for CAB files that is generated. After complete, you can restore it by
right clicking the Server Name.
Good luck!

You cannot copy a cube. The best alternative is to bring up Analysis
Manager, connecting to both servers and then do a copy-and-paste between the
databases. Then you will need to do a full process.

An alternative to the metdata scripter from the SQL 2K Resource Kit is the
DSO/XML utility available here:
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

I've try it
but I have to modify manually the XML file to change the target database
name and its not so easy to use.
ans also, I've some problem to apply the XML document, I receive some schema
errors.

I'm looking for a solution integrated into the analysis manager directly.
(if possible)

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: Op6Mg2z4EHA.2568 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Copy-Paste and then reprocess is the only way.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

well... there is something wrong in my databases I presume.
I'll done some other tests to find a good way

thanks for your time.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> a écrit dans le
message de news: OlmQQh94EHA.1264 (AT) TK2MSFTNGP12 (DOT) phx.gbl...