I enhanced the solution including all tables into the schema ipeds in backend and zcube databases. As outcome we can find the schema ipeds_backup which is a backup of all old tables and the schema ipeds whose tables just contain universities that are into the ipeds_dims.university table.
The following tables are a summary in each schema, zcube and backend respectively, where qt_new(qt_old) is the number of row to the table in ipeds(ipeds_backup) schema, diff is the is the difference between previous columns and univ_name_null is just a classified which identify if the old table had null names (where in all cases is yes)
I enhanced the solution including all tables into the schema
ipeds
inbackend
andzcube
databases. As outcome we can find the schemaipeds_backup
which is a backup of all old tables and the schemaipeds
whose tables just contain universities that are into theipeds_dims.university
table.The following tables are a summary in each schema,
zcube
andbackend
respectively, whereqt_new
(qt_old
) is the number of row to the table inipeds
(ipeds_backup
) schema,diff
is the is the difference between previous columns anduniv_name_null
is just a classified which identify if the old table had null names (where in all cases isyes
)