Syncronization with transformation I have the following scenario: a database in SQL Server 2012 that must replicate changes in a transactional way to a SQL Server 2000 database.  Since the schemas of two databases differ, a transformation must be made for the destination.  Both databases are in the same network.
What's the better approach?


Use triggers in the source database to make the transformations and perform the changes in the destination.
Use SQL Server transactional replication (but transformations seems not possible, as I know).
Any alternative?
Use a linked server as Aaron mentioned and bulk load your data to your SQL 2000 tables after doing the transformation within SQL 2012. You could just create a few staging tables in SQL 2012 where you can place your transformed data as it comes in.

Beware of linked server from 2012 to 2000 using SQLNCLI10: see here
SQLNCLI10

The new client SQLNCLI11 does not work with SQL 2000 as far as I know.