Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Deployment through Deployment Script Expand / Collapse
Author
Message
Posted Tuesday, April 7, 2009 6:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 5, 2013 12:58 AM
Points: 16, Visits: 191
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
Post #691886
Posted Tuesday, April 7, 2009 6:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 464, Visits: 463
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.

Post #691940
Posted Tuesday, April 7, 2009 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 5, 2013 12:58 AM
Points: 16, Visits: 191
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.
Post #692121
Posted Tuesday, April 7, 2009 9:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 464, Visits: 463
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.
Post #692232
Posted Tuesday, April 7, 2009 9:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 5, 2013 12:58 AM
Points: 16, Visits: 191
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
Post #692726
Posted Wednesday, April 8, 2009 4:30 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 464, Visits: 463
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.
Post #692913
Posted Wednesday, November 13, 2013 10:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:40 AM
Points: 2, Visits: 27
What does the copy to output directory property do? what is the source file that it copies to the output directory??
Post #1514141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse