Hello,
in our organisation we use 6 databases which "should" have the same amount of tables, within the tables the columns should have the same structure (amount of columns,datatyp e and column order)
I am building a new database to merge all the databases into 1 for reporting reasons, which for the major part works. But apparently, there are some differences within the amount tables and the amount/type of columns within some of the tables.
I would like to have a script which goes over each table in every database and analyses it, so that I will get an overview which tables differ in the databases, which columns differs in any way (more columns, other datatype or other column order within the table).
It is a kind of an audit I would like to do on the 6 'so called' identical database.
Anyone an idea on how to proceed on this? Or does anyone have a script like this?
Many thanks
Guido
in our organisation we use 6 databases which "should" have the same amount of tables, within the tables the columns should have the same structure (amount of columns,datatyp e and column order)
I am building a new database to merge all the databases into 1 for reporting reasons, which for the major part works. But apparently, there are some differences within the amount tables and the amount/type of columns within some of the tables.
I would like to have a script which goes over each table in every database and analyses it, so that I will get an overview which tables differ in the databases, which columns differs in any way (more columns, other datatype or other column order within the table).
It is a kind of an audit I would like to do on the 6 'so called' identical database.
Anyone an idea on how to proceed on this? Or does anyone have a script like this?
Many thanks
Guido