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