SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag AMO Rss

Refine your search with one of the following additional tags (with number of items):

Analysis Services (SSAS) (6)     Cube (1)     SQL Server 2008 (1)    
powershell (5)     detach (1)     XMLA (1)    
Dimensions (2)     Integration Services (SSIS) (1)    
   Items 1 to 7 of 7   
 

Script a cube using Windows PowerShell and AMO

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.  Read more...
By Additional Articles 2009/05/12 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 969 reads

Script dimensions using Windows PowerShell and AMO

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.  Read more...
By Additional Articles 2009/05/01 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |  Briefcase | 886 reads

Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO

This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.  Read more...
Rating:  Rate this |  Briefcase | 1,094 reads

Process Dimensions in an Analysis Service database

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 1,022 reads

Get SSAS Database Properties with PowerShell and AMO

Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.  Read more...
By Additional Articles 2009/01/05 | Source: Database Journal | Category: AMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,029 reads

Discover Analysis Service's Properties using Windows PowerShell and AMO

Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.  Read more...
By Additional Articles 2008/12/12 | Source: Database Journal | Category: AMO
Rating: (not yet rated)  Rate this |  Briefcase | 1,140 reads

Managing SQL Analysis Service Objects with SSIS and AMO

You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.  Read more...
Rating: |  Discuss |  Briefcase | 3,273 reads
   Items 1 to 7 of 7