[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
|
| Created: | Tue Aug 23 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
360.0. "Replicating with different col names" by NEWVAX::RAK () Thu Apr 10 1997 14:22
It's possible to change table names in a replication.
For example, we can publish from table "Customer" to "CustomerS".
Any ideas on how to achieve similar functionality at the column level?
For example, publish from Customer.Customer_ID to CustomerS.CustID?
So far, the best we've come up with is:
Option a:
Rebuild schema and rewrite application
Option b:
Replicate to an intermediate table
Define triggers on the intermediate table that
insert/update/delete the target table
| T.R | Title | User | Personal
Name | Date | Lines
|
|---|