Home Dashboard Directory Help
Search

SSAS Deploy: Need option to NOT overwrite data Sources by Todd C


Status: 

Active


4
0
Sign in
to vote
Type: Suggestion
ID: 538600
Opened: 3/3/2010 10:32:33 AM
Access Restriction: Public
0
Workaround(s)
view

Description

I'm heavily into Microsoft BI suite. Seems the Deploy function of SSRS works great, in that you can specify OverwriteDataSources = False in the Project Properties.

Aside: (Yeah, you still get a WARNING that says:

Deploying data source '/Data Sources/<MyDataSource>'.
Warning : Cannot deploy data source <MyDataSource> to the server because it already exists and OverwriteDataSources is not specified.

even though you TOLD it NOT to Deploy said DataSource. But this issue is listed under another Feedback.)

Moving on, When you Deploy in SSAS, your DataSources on the server get overwritten. There is NO ability to switch between dev/test/production scenarios.

The only option you have is to BUILD the project to a folder, then MANUALLY edit the <projectName>.ConfigSettings files (and possible others), then invoke the SSAS Deployment utility.

Too many manual steps, especially if you have multiple DataSources and multiple ReportActions.
Details
Sign in to post a comment.
Posted by Microsoft on 3/15/2010 at 7:39 PM
Todd -- Thank you for filing this design change request. We will investigate for a future release of SQL Server and update this item when we have more information to report.

Sincerely,
The Analysis Services team
Sign in to post a workaround.