Posted by Erland Sommarskog on 12/04/07 22:30

JoshG (jsgough@gmail.com) writes:
> There is one complicating factor I neglected to mention.
>
> In several tables, we have columns currently poorly named "ID_ref" or
> "CustomerID_ref". In the new version of the database, we have simply
> renamed these to ID or CustomerID.
>
> Using a view, we can easily keep using the ID_ref but map it to the
> new physical ID column in the new database.
>
> From looking at synonyms so far, I don't think you can do this kind of
> mapping. Do you know if that is the case for sure?

Right, if you are also changing column names or anything else, synonyms
are not for you.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Add a datestamp to an existing table
• Prev in forum: Re: multi column sub select equivalent for sql server 2005
• Thread view: Re: Using updatable views when moving tables from one DB to another?

[Reply to this message]