Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Compare Different tables from 2 Databases Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2008 3:38 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:49 PM
Points: 510, Visits: 270
Comments posted to this topic are about the item Compare Different tables from 2 Databases
Post #457894
Posted Tuesday, April 8, 2008 12:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:14 AM
Points: 251, Visits: 656
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 ;)



Post #481315
Posted Tuesday, April 8, 2008 4:56 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:49 PM
Points: 510, Visits: 270

Hi, You can do this:

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

Thanks
:D

Jose Anchieta C. Jr
Post #481936
Posted Thursday, April 10, 2008 12:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:14 AM
Points: 251, Visits: 656
Jose, thanks.
Could I also use an empty string (eg '') for the table(s) to compare all the tables?



Post #482783
Posted Thursday, April 10, 2008 10:31 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:49 PM
Points: 510, Visits: 270
Yes, see:

exec dbo.PD_Lista_Tabela_Diferente 'databaseNew' , 'databaseOld'', ''
Post #483165
Posted Friday, January 6, 2012 12:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 9:18 AM
Points: 1, Visits: 45
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
Post #1231670
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse