sql server replication: Replicating one table to another table (with different structure) -- sql server replication

Replicating one table to another table (with different structure)

vsp
3/30/2007 4:38:03 AM

sql server replication: I have 2 databases and plan to user transactional or snapshot replication to
replicate data from db1 to db2. db1.table1 name char(20), addr char(500) and
db2.table2 has entity char(20), addr1 char(100), addr2 char(100) etc.
Table Names & column Names and different but type remain same.

Can someome guide?

Thanks in anticipation.

Re: Replicating one table to another table (with different structure)

Hilary Cotter
3/30/2007 8:01:25 AM

Either create an indexed view which has the schema of the table on the
subscriber and replicate that as a table, or use a custom sync object and
creation script to replicate your table.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]