change schema references in same model

[ry1633]

Hi all,

Is there a easy (ish) way to remove/change the schema references in my model?    Turns out I used the wrong path for all of my query subject in my model -- I should have used their synonyms that my DBA created for me under a different path.  I'd much prefer to not have to recreate my entire model and re-write all the relationships again if I can absolutely help it.

How do I do it with the data Synonyms that are in a different locations?   (same names as all of my objects I'm currently using.  Just in a different data location...)

[ry1633]

The old path was [Schema] / Views and the new path should be [Schema2] / Synonyms -- other wise everything is the same.

If I just change the Schema properties of the existing data source to point to [Schema2] would that work?   

[ry1633]

I might have gotten it to work but I would still covet some advice and help.  Some please feel free to chime in.

I did two things...I tried two things...

I used the path to the Synonyms that my Oracle DBA gave me and I also blanked out the Schema name in the Data Source properties of the model.  There might also be some behind the scenes magic my DBA haven't told me about how they've linked the dev and accept/prod environments.  :)

[bus_pass_man]

The data source connection properties are designed to be swappable.

If I just change the Schema properties of the existing data source to point to [Schema2] would that work?   

I don't know but if you try it we'll learn soon enough.   IIRC there isn't a distinction about object sources (tables/views/synonyms) in the object other than (I think) an indication in the model (check that by selecting something you want to retarget and look at tools/model report )that the object is a view or synonym.   You might need to tools (or is it actions?)/ update object after changing the data source connection property values.   

It'll probably bugger up some of your usage settings if you changed them after the original import and you would have to change them back.

If you really want to make sure that the properties are exactly what you want them to be one trick would be to create a new project, import some stuff from your data source which you want to use and select the data source connection which is created. 


There's remap to new source, which allows you to change your object references but it is geared more for the swapping out of data layers and you don't want to redo the work that you've done in defining relationships.

The relationship editor has provision for changing the ends of the relationships from one query subject to another so some of your work would not be lost although the key strokes necessary to do the swapping and re-defining which keys to use will only be slightly less than defining the relationships ab initio.