No differences detected in SQL Compare

f4l

Hi, I have two dbs on separate servers.  One was copied to the other approximately a month ago, and since then I have been making changes on one of them. So I have server 'Live' with db named 'abc' and server 'Test' with db also named 'abc'.

I now want to copy the changes made in the last month in Test, onto Live so am using SQL Compare to identify the changes, but comparing the two shows all tables are identical.

Tables are showing different results when I select top 1000 from both in SSMS.

Dan_J

Hi @f4l

Thanks for reaching out to us regarding this.

Just to check, are the changes you've been making been to the database structure, or to the data within the database?