Post reply

Compare Different tables from 2 Databases

  • February 20, 2008 at 3:38 am

    #183136

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

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

  • 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

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

  • April 10, 2008 at 10:31 am

    #801084

    Yes, see:

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

  • January 6, 2012 at 12:22 pm

    #1429810

    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

  • May 11, 2016 at 7:15 am

    #1878204

    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