February 20, 2008 at 3:38 am
Comments posted to this topic are about the item Compare Different tables from 2 Databases
April 8, 2008 at 12:28 am
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
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
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
Yes, see:
exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', ''
January 6, 2012 at 12:22 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy