samprg
asked on
SQL2008 cube copy
1-I need to copy from one database to another at same server
Thank you
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello,
My question on the "copy cube" not "copy database"
Thanks
My question on the "copy cube" not "copy database"
Thanks
Create script of existing Cube and execute on the other database on which you wanna create.
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/