I currently have two database servers, production and development.
The development database server has a specific database that I modify both schema design (for tables) as well as some data.
I would like to compare the data between the two tables, between the two servers as well as any design differences.
Is it possible to do so with SQL Data Compare or SQL Compare? I have the developers bundle and license.
There are only a few new rows that I know I need to copy from development -> production.