SSAS Deployment through Deployment Script

  • We have four file in SSAS bin directory i.e.

    XMLA file

    .asdatabase

    .deploymenttargets

    .configsettings

    .deploymentoptions

    How to deploy on SSAS production server by using the above files.

    Regards,

    kamal maurya

  • Check out Analysis Services deployment wizard in BOL : http://msdn.microsoft.com/en-us/library/ms176121.aspx.

    I also use ASCMD in a batch file to release the XMLA scripts into prod environment.

  • Thanks for your comment . I gone through the given msdn link but could not find how to deploy the XMLA scripts file to production server.

    Can you please elaborate on this.

  • After you create a SSAS project and build it using BIDS, you will get the list of the files that you have mentioned. Then use Analysis Services deployment (wizard or command line utility :http://msdn.microsoft.com/en-us/library/ms162758(SQL.90).aspx ) that will take these files as input and will deploy the cube to the server that you specify.

    You can alternatively use the wizard to create XMLA file and then execute it using SSMS or using ascmd utility from command line.

  • Thanx for your comment..

    We have to run all below three commands in command prompt in three steps and my all four scripts should be in bin directory.

    Run Step 1 in command prompt:

    Microsoft.AnalysisServices.Deployment.exe

    Run Step 2 in command prompt:

    :\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\bin

    Run Step 3 in command prompt:

    /s: C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\bin\deployment.log

    After running Successfully all three steps one after one my ssas packaGE WILL BE deploy in analysis server.

    Please let me know whether is it the correct procedure?

    kamal maurya

  • Step 1:

    Open your SSAS project in IDE and build it. It will generate the following files in bin folder

    - YourDB.asdatabase

    - YourDB.configsettings

    - YourDB.deploymentoptions

    - YourDB.deploymenttargets

    Step 2:

    Run the Analysis Services deployment wizard, speciy the SSAS database to the YourDB.asdatabase file and set the options that you need.

    In the confirm deployment option, select "Create deployment script" option and specify a path.

    This will create a XMLA file

    Step 3:

    Now you have 2 options to release the SSAS DB to your production server

    option 1 : Connect using SSMS and execute the xmla script.

    option 2 : If you want to run it as part of the batch file, use ascmd.exe to release it.

  • What does the copy to output directory property do? what is the source file that it copies to the output directory??

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

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