​When we are performing Snapshot replication where Publisher is SQL Server 2008 and Subscriber is SQL Server 2019. We are receiving below mentioned errors.

Error messages: The process could not bulk copy into table '"dbo"."Car"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037) Get help: http://help/MSSQL_REPL20037 metadata query failed Invalid character value for cast specification (Source: MSSQLServer, Error number: 22018) Get help: http://help/22018 Unspecified error

When we change compatability level of subscriber database to 120 then snapshot replication is working successfully.

Is there anyway by which we can perform snapshot replication successfully without changing the compatability level?.

1 Answer 1


The replication version compatibility rules are documented here: Replication Backward Compatibility (snapshot falls under Transactional Replication).

SQL Server 2008 is out of support, and replication between SQL 2008 and SQL 2019 is unsupported. So probably not.

  • Browne Thanks for response Now I understood it. Commented Jun 8, 2020 at 12:07
  • @AbhishekModgi it looks as tho your accounts got split. You can use the link here dba.stackexchange.com/help/merging-accounts to get in touch with the community team to let them help you connect them!
    – jcolebrand
    Commented Jun 8, 2020 at 21:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.