1

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?

  • 3
    what is your db compatiblity level ? Run SELECT name, compatibility_level FROM sys.databases WHERE name = 'YOURDBName' and then you can use ALTER DATABASE [YOURDBName] SET compatibility_level = 110 -- 2012 version. – Kin Shah Jun 26 at 13:22
  • The compatibility level was 90. I'll see if we can change that without breaking any queries. – Mathias Rönnlund Jun 26 at 16:06
1

converting my comment to answer ...

Since you confirmed that the db compatiblity is 90 which is sql 2005

Run

SELECT name, compatibility_level 
FROM sys.databases WHERE name = 'YOURDBName' 

and then you can use ALTER DATABASE [YOURDBName] SET compatibility_level = 110 -- 2012 version

  • I can verify that changing the compatibility level to 110 got things working and the replication in now running. – Mathias Rönnlund Jun 27 at 11:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.