Compare 2 different tables columns from 2 different databases
sql, sql-server, sql-server-2008
Solution
Is it just red-gate tools you don’t want to use or basically any third party tool? Why not, even if you don’t have the budget to buy you can still use this in trial mode to get the job done?
We’ve been using Apex Diff tool but there are many more out there.
With so many tools available you can probably run all one by one in trial mode for months…
Knowing system tables and how to do this natively is great but it’s just too time consuming...
Problem
I have a requirement to compare different tables' columns from 2 different databases, in order to add columns to the master tables based on the requirement. For example: Assume in master database I have created one table like: ``` create table test(id int,name varchar(10)) ``` Assume in test database I have created one table like ``` create table testings(id int,name varchar(20), sal int) ``` now I have to compare 2 table columns I don't want to use red-gate tools. Can anyone help me?