We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says
Column mycolumn in object mytable contains type Date, which is not supported in the target server version, SQL Server 2005.
Since Azure Sql Database should support Date datatype Data types the problem could be that Sql Server identifies Azure Sql Database as version 2005.
Is there a way to get this working?