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.)