I am using a script to copy data from a subset of tables in one server to a second server, such that the second server has fewer tables than the original. Data should otherwise be identical.
I recently learned there is a DB compare tool in recent versions of VS, so I installed it and restarted VS. I then pointed the tool to the two servers and ran a table compare. This returned immediately with "0 tables and/or views were compared."
There seemed to be only three steps, select the two databases, select what you want to compare (tables) and then click Finish.
There are no errors, dialogs, warnings or output in Output or Immediate. I know it is connecting to the two DB's because I can pop-up the table list successfully, which I couldn't when I forgot to check the trust cert.
Did I miss something?