SQL Server: compare columns in two tables.

views:

407

answers:

+3 Q:

SQL Server: compare columns in two tables.

Hi, I've recently done a migration from a really old version of some application to the current version and i faced some problems while migrating databases.

I need a query that could help me to compare columns in two tables. I mean not the data in rows, I need to compare the columns itself to figure out, what changes in table structure I've missed.

+6 A:

Realy it is a big script. :)

Use red gate sql compare. They offer you 14-day free trial

If you realy need script it can be a text and than you can compare both by using any text comparer.

igor 2010-03-11 20:15:29

I'll give it a try. Thanks.

maxt3r 2010-03-11 20:22:05

@igor is right, don't write this yourself, there are loads of applications to do this. Apex SQL Diff is another with a free trial.

Tony 2010-03-11 20:24:34

+5 A:

Gaby 2010-03-11 20:22:38

Nice! Thanks a lot. I also found a build in stored procedure sp_columns which expects table name as a param.