Compare Different tables from 2 Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by jrtupa » Compare Different tables from 2 Databases

Compare Different tables from 2 Databases

Rate Topic

Display Mode

Topic Options

Author

Message

JoseACJr

Posted Wednesday, February 20, 2008 3:38 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:25 AM
Points: 438, Visits: 229

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

Post #457894

Henk Schreij

Posted Tuesday, April 08, 2008 12:28 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:02 AM
Points: 235, Visits: 560

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

JoseACJr

Posted Tuesday, April 08, 2008 4:56 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:25 AM
Points: 438, Visits: 229

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

Henk Schreij

Posted Thursday, April 10, 2008 12:14 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:02 AM
Points: 235, Visits: 560

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

Post #482783

JoseACJr

Posted Thursday, April 10, 2008 10:31 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:25 AM
Points: 438, Visits: 229

Yes, see:

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

Post #483165

Chris Green-421589

Posted Friday, January 06, 2012 12:22 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 1, Visits: 39

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 »

Permissions