Is there a cross-platform way to compare data in one columnd on each sitde of replicated data, like a checksum or hash?
The Oracle function for hashing is called
Standard_hash()
which supports these methods :- SHA1, SHA256, SHA384, SHA512, and MD5
https://docs.oracle.com/database/121/SQLRF/functions183.htm#SQLRF55647
In SQL Server you can use Hashbytes()
which supports these methods :- MD2, MD4, MD5, SHA, SHA1, or SHA2_256, SHA2_512
https://docs.microsoft.com/en-us/sql/t-sql/functions/hashbytes-transact-sql?view=sql-server-ver15
As they both support SHA2_256 or SHA2_512 I would start by setting up a few rows of test data and check that they produce the same result.
a search also throws up the following link
http://roelantvos.com/blog/hashing-in-sql-server-and-oracle-for-the-same-output/
EDIT :  I reread the comments &amp; saw that you were concerned that standards for conversions of decimals to strings etc were not standard - I think you could fairly easily address this by using the schema &amp; type views to dynamically construct conversion queries using CASE statements etc, &amp; at least it only has to be done on one side.