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?.