dbTalk Databases Forums  

Importing an Analysis Services 2005 Database

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


Discuss Importing an Analysis Services 2005 Database in the microsoft.public.sqlserver.olap forum.



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

Default Importing an Analysis Services 2005 Database - 06-20-2006 , 02:52 PM






I'm having an issue when I create a new project of type "Import
Analysis Services 9.0 Database". It reverse engineers just fine, but
when I change my server name and database name in the project properies
and try to deploy, it tells me the database already exists and it will
be overwritten. This is when I make non-breaking or NO changes.

Since I just reverse engineered it, shouldn't it be able to deploy the
changes only?

Has anyone else had this issue?


Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: Importing an Analysis Services 2005 Database - 06-20-2006 , 06:20 PM






when you do a "reverse" eng. the solution save an ID which is the last time
you have published the solution.
Because the solutiion is new, VS detect that the current version on the
server is out of sync, so the VS will replace the current version.
after this, only changes are deployed (generally)
This behavior appears if the server version is newer then the VS Solution
version.

if you want to modify an existing deployment, instead-of doing a reverse
eng. simply edit the cube online.
Open VS, open the cube directly by doing a file / open / open AS database
when you save, the change is saved directly on the server.
(like we edit a cube / dimension in AS2000)



"Todd" <toddkitta (AT) gmail (DOT) com> wrote

Quote:
I'm having an issue when I create a new project of type "Import
Analysis Services 9.0 Database". It reverse engineers just fine, but
when I change my server name and database name in the project properies
and try to deploy, it tells me the database already exists and it will
be overwritten. This is when I make non-breaking or NO changes.

Since I just reverse engineered it, shouldn't it be able to deploy the
changes only?

Has anyone else had this issue?




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.