Export all objects within database for future use

Hi,
I develop in SQL Server as well as MSAS at work. I also have SQL Server
with MSAS loaded on my home PC. Is there a way I can "take" the contents of
the database at work and work on it from home then upload the changes when
I'm back at work? I'm going on vacation and would still like to develop
while I'm out of the office.
Also, is it then possible to export the and then reimport the cubes I've
built as well?
Thanks.
Hello Jason.
you should look at the product I developed after many years of thinking
about database change management. Our web-site also has a white paper on the
subject of automated database change management using your source control
which is the only way (as far as I'm concerned) to guarentee total control
over your source and what is delivered.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Jason" wrote:

> Hi,
> I develop in SQL Server as well as MSAS at work. I also have SQL Server
> with MSAS loaded on my home PC. Is there a way I can "take" the contents of
> the database at work and work on it from home then upload the changes when
> I'm back at work? I'm going on vacation and would still like to develop
> while I'm out of the office.
> Also, is it then possible to export the and then reimport the cubes I've
> built as well?
> Thanks.
>
sql