A client has a highly customized SL 2011 FP1 installation with numerous table names starting with "x". They would like to move these custom tables to either a different database or different schema (long story). I originally thought we could use synonyms for this -- simply move a given table and create a synonym pointing to its new location.
But when I try doing this with one table, named xCut, I get an error in the DbNav property (where the query is a simple SELECT * FROM xCut WHERE cut LIKE @parm1).
This seems to indicate the synonym is not working within SL. But I don't understand why.
Does anyone know if it's even possible to use synonyms with SL?
Thanks for any help!
No it is not possible to use synonym's within SL. Trying to use synonyms with the SWIM setaddr, fetch, etc... calls, those calls assume either a table or a view. When you first log into Dynamics SL, the system fetches a list out of sysobjects where type is U or V. It's not looking for type SN. So the system would not be aware of your synonym object and wouldn't know it existed.
Technical Support Engineer
**This posting is provided "AS IS" with no warranties and confers no rights.
Thanks, Cory, for such a thorough and succinct explanation!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics