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, call it xCustomTable, I get an error in the DbNav property (where the query is a simple SELECT * FROM xCustomTable WHERE CustomField 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?