April 12, 2012 at 11:45 pm
Hi All,
I am having a problem while migrating cube from dev to prod.
My source is Oracle having different schema names in dev and prod consider dev schema name dev1 and prod schema name is prod1
I am having named queries in the cube with schema name as sufix.
All the times when there is modification in the cube it becoming problem while migrating from dev to prod with the schema name.
I can not change the schema names of prod and dev.
What to do?I need a solution for this.
It is very urgent.
Please help me
Thanks in advance
Regards
Vaibhav
April 12, 2012 at 11:49 pm
That's quite a horrible practice.
Every single piece of code that you write on dev using a schema will break when you deploy it to production.
You could try to create views in dev and prod that use the same schema?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 12, 2012 at 11:52 pm
Hi Thanks for the reply.
At this point of time I can not do any thing on schema name.
Is there any chance to create a variable and can pass the schema name to the variable?
Regards
April 12, 2012 at 11:54 pm
I don't think so. In SSIS this is possible, but in SSAS?
How do you deploy from DEV to PROD?
Maybe you can do a simple search and replace on the schema name.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 12, 2012 at 11:58 pm
Not really..,I opened each named query and modified the schema name for the first time.
From next time onwards i kept two copies prod and dev.
First I will test in dev and I will modify the same in production.
Ofcourse it is very bad praactice but no other go.
Please help some body if there is any way
April 13, 2012 at 12:07 am
Vaibhav.P (4/12/2012)
Not really..,I opened each named query and modified the schema name for the first time.
Why is search and replace not an option? A SSAS database is just a collection of XML files.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 13, 2012 at 12:38 am
I don't think that is good option...,cause if any of the objectid is with same name may create other problem(ofcourse can do by finding each one and then can replace).
But I wanna a professional way of setting of this.
Regards
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply