dbTalk Databases Forums  

Default SSAS database name for deployment

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Default SSAS database name for deployment in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kevin Dente
 
Posts: n/a

Default Default SSAS database name for deployment - 02-23-2006 , 11:46 AM






We've got an SSAS2005 BI project, and I'm trying to generate an XMLA
deployment script for it. I'm running the Deployment Wizard is command-line
mode, using "/o" to generate an output file and /d to avoid connecting to
the target instance (I want to ultimately do all this on a build machine,
with no SSAS running).

What I'm trying to figure out is how the build code code selects the
default database name when it compiles the .asdatabase and
..deploymenttargets files. What I'm observing is very strange.

If I bring up the project properties and set the target database in
there, the setting goes in to the .dwproj.user file, and the build processes
uses it. But that's a user specific settings file, which I wouldn't
ordinarily expect to check in to source control.

When I look in the <project>.database file, there's a <Database>
element with a <Name> child. But it doesn't seem to use that (nor the ID).

I tried change the name of the project to see if that's what
determines it, but that doesn't seem to change the database name in either
of the built files.

So is there something I'm missing here? Is there some way to change
the default database name for deployment outside of the .user file setting?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.