Compare Different tables from 2 Databases

• JoseACJr

  SSC Eights!

  Points: 932

  More actions

  February 20, 2008 at 3:38 am

  #183136

  Comments posted to this topic are about the item Compare Different tables from 2 Databases

• Henk Schreij

  SSCarpal Tunnel

  Points: 4553

  More actions

  April 8, 2008 at 12:28 am

  #799550

  Sorry, but the "how to use" is missing.

  I only see two scrollbars, without any text.

  Please could you add a "how to use" in this discussion.

  The problem is that the names used are self-explaining but in Spanish.

  And names like DBFontes, DBVerifica, Iniciais_Nome_Tabela are not self-evident to me 😉

• JoseACJr

  SSC Eights!

  Points: 932

  More actions

  April 8, 2008 at 4:56 pm

  #800061

  Hi, You can do this:

  exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', 'p' --names of tables that start whit "p"

  Thanks

  😀

  Jose Anchieta C. Jr

• Henk Schreij

  SSCarpal Tunnel

  Points: 4553

  More actions

  April 10, 2008 at 12:14 am

  #800773

  Jose, thanks.

  Could I also use an empty string (eg '') for the table(s) to compare all the tables?

• JoseACJr

  SSC Eights!

  Points: 932

  More actions

  April 10, 2008 at 10:31 am

  #801084

  Yes, see:

  exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', ''

• Sethran

  Newbie

  Points: 5

  More actions

  January 6, 2012 at 12:22 pm

  #1429810

  Should all columns in the output query be populated? These fields are: TABLE_CATALOG_DBFontes TABLE_NAME_DBFontes COLUMN_NAME_DBFontes DATA_TYPE_DBFontes

  But these fields are just returning NULL: TABLE_CATALOG_DBVerifica TABLE_NAME_DBVerifica COLUMN_NAME_DBVerifica DATA_TYPE_DBVerifica

  Nice script!

  Thanks

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2016 at 7:15 am

  #1878204

  Thanks for the script.