Compare Different tables from 2 Databases

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

  • 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 😉

  • 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

  • Jose, thanks.

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

  • Yes, see:

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

  • Should all columns in the output query be populated? These fields are: TABLE_CATALOG_DBFontesTABLE_NAME_DBFontesCOLUMN_NAME_DBFontesDATA_TYPE_DBFontes

    But these fields are just returning NULL: TABLE_CATALOG_DBVerificaTABLE_NAME_DBVerificaCOLUMN_NAME_DBVerificaDATA_TYPE_DBVerifica

    Nice script!

    Thanks

  • Thanks for the script.

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

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