Differentiating between two Schemas

Breako · #1 (**permalink**) 12-12-11, 07:10

Hi,
Is there anyway to differentiate between two schemas between two SQL server instances?

onansalad · #2 (**permalink**) 12-12-11, 10:57

Would depend on what you mean by "differentiating." While I haven't tried this with two instances on the same server, I've often created linked servers across two different servers so I can reference them with the linked server syntax. For instance - to find records in a prod table that don't exist in a dev table:

Code:

select       *
from         [SERVER1].[DBNAME].[SCHEMA].[OBJECTNAME] x left outer join 
             [SERVER2].[DBNAME].[SCHEMA].[OBJECTNAME]y on x.id=y.id
where        y.id is null

shendricks · #3 (**permalink**) 12-12-11, 19:36

If you are looking for differences in schema definitions, I'd use a third party tool. The Red Gate SQLCompare is what I've used with good results. It will generate the scripting needed to sync the schemas, too.

Internet Services

Web Development

Digital Marketing

Consumer Tech