How can I diff a Postgres table against a sqlserver table
Bogopo last edited by
We are in the process of migrating from
sql server 2008R2to
We have created the appropriate tables and populated them and have our apps writing to both databases.
What is the best way to diff tables on both databases to ensure that we are properly writing to both database's properly.
We can assume sql server is correct as this is our current production database.
Marcee last edited by
If the tables are identical it is easiest to compare using the foreign data wrapper for mssql. Doing so gives you access to both at the same time, looking from the Postgres side.