Обсуждение: verifying data integrity after migrating for postgres 7.3 to postgres 8.1

Поиск
Список
Период
Сортировка

verifying data integrity after migrating for postgres 7.3 to postgres 8.1

От
Najib Abi Fadel
Дата:
Hi,

i migrated my database from postgres 7.3 to postgres
8.1.

I was wondering if there is a way to verify that data
has been well copied betweeen the 2 versions !

I thought about writing a script that will verify that
we have the same tables and the same number of lines
per table between the 2 databases.

Has anyone done that before ?

Is there any other way for verification ?

Thanks in advance for any help.

Najib.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com