I have a question!
Is it possible to use Change Data Capture on "replicated" tables?

You see,
I am in charge of a Datawarehouse and I would like to use the "Change Data Capture" feature to load data from the source databases into the datawarehouse.


The datawarehouse will very soon run on Sql Server 2008 Enterprise edition, but the server of the source databases unfortunately runs on SQL Server standard edition, so Change Data Capture is not available there.


Would it be possible to overcome the fact that the server of the source databases lack enterprise edition by doing the following:

1. Replicate the sourcedatabases from the source server into the datawarehouse server (which e.g runs enterprise edition)
2. Utilize Change Data Capture on the replicated tables that after (1) above exists in the datawarehouse server.


What do you think?