Compare Different tables from 2 Databases

  • JoseACJr

    SSC Eights!

    Points: 934

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

  • Henk Schreij

    SSCarpal Tunnel

    Points: 4553

    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: 934

    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

    Jose, thanks.

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

  • JoseACJr

    SSC Eights!

    Points: 934

    Yes, see:

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

  • Sethran

    Newbie

    Points: 5

    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

    Thanks for the script.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply