Compare two database with 3 output

Anonymous — Thu, 08 Dec 2016 16:23:09 GMT

Hello,

I try to compare two tables. But I can't find a solution.
The problem :
I work on MSSQL.
I want to list all of tables on DB. Request is :

select table_name from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE'

Next I want compare the results. But with Tmap and look up doesn't work.
In fact I would like 3 results :
- File csv with the list of table which exist both.
- File csv with the list of table which not exist on DB 1
- File csv with the list of table which not exist on DB 2
For the moment, my result is a file with list of table which exist both.
I don't know what to do anymore.
Thank's in advance,

My job :

Re: Compare two database with 3 output

vapukov — Thu, 08 Dec 2016 21:57:16 GMT

You can use combination of 2 lookups (check also settings on pictures):

Re: Compare two database with 3 output

Anonymous — Fri, 09 Dec 2016 09:56:56 GMT

Thank !!!!!
That works!!!

topic Re: Compare two database with 3 output in Installing and Upgrading

Compare two database with 3 output

Re: Compare two database with 3 output

Re: Compare two database with 3 output