I've two different databases that share a few of the same tables, and differ with a couple of tables. It is possible to way will be able to have an creation of the variations between only the table names within the databases?
I am using MS SQL Server, and each of the tables are on a single DB server.
Use a database compare tool like DBComparer Its totally free too and is effective for me personally.
You want to be aware of difference in table names? You are able to outer join onto
sys.tables with this.
;WITH A AS (SELECT * FROM msdb.sys.tables WHERE type = 'U'), B AS (SELECT * FROM master.sys.tables WHERE type = 'U') SELECT COALESCE(A.name, B.name) AS Name, CASE WHEN A.name IS NULL THEN 'A' ELSE 'B' END AS DB FROM A FULL OUTER JOIN B ON A.name = B.name WHERE ( B.name IS NULL OR A.name IS NULL ) ORDER BY DB, Name