Transactional Replication on a table carrying incompatible data type

I am trying to implement a transactional replication in 2008. Both the publisher and subscriber are in 2008 version.So far so good.

The publisher database is in 2005 compatibili开发者_高级运维ty mode. It has a table which has two columns with the data type 'date' which is new in 2008. So for the replication, when bcp files are generated while taking initial snapshot, because the publisher is in 2005 mode, it generates a snapshot thinking that it is going to apply the same on a 2005 mode db and thus the snapshot fails because 'date' data type is not supported in 2005.

Please suggest some remedy other than changign the compatibiliy level. Is there any option which i can choose to tell the snapshot agent that it should generate snapshot for a true 2008 susbcriber.

Thanks in advance!

Chandan Jha

The db is on 2008 server but its compatibility mode is 2005. So when the snapshot agent reads the schema of the table it fails to script it because date is not a supported data type in 2005.