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?

Improve this question
2
  • 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. Commented Jun 26, 2019 at 13:22
  • The compatibility level was 90. I'll see if we can change that without breaking any queries. Commented Jun 26, 2019 at 16:06

1 Answer 1

Reset to default
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

Improve this answer
1
  • I can verify that changing the compatibility level to 110 got things working and the replication in now running. Commented Jun 27, 2019 at 11:31

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.