Renaming destination table name and destination column name at subscriber for transactional replication

  • I have a publisher database running on SQL Server 2000 to be published to a SQL Server 2008 database via transactional replication. Is it possible to do the following:

    1. Rename the table on the subscriber database (i.e., SQL 2000's Table A will appear as Table B in SQL 2008).

    2. Rename a table column on the subscriber database (i.e., SQL 2000's Table A, Column A1 will appear as Table A, Column B1 in SQL 2008.)

    3. Rename a table and corresponding column on the subscriber database (i.e., SQL 2000's Table A, Column A1 will appear as Table B, Column B1 in SQL 2008.)

  • Google searching revealed that sp_addarticle's @destination_table stored procedure parameter could be used for scenario 1. However, I'm not sure how to accomplish scenario 2 and whether scenario 2's solution would affect scenario 3.

  • You could probablt accomplish the column renaming part by customizing the applicable sp_MSins and sp_MSupd stored procedures in the subscriber database.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply