I have migrate 3 db into a unique db (sqlserver) and I would like write of the validation tests to verify if the database resulting is OK or not.
How write these tests ? with a tool (free) or of the scripts (sql, perl or...).
Do you want to compare the records of source and destination databases? I am not very sure whether objects comparison utility is available in SQL Server or not. For the same purpose there is tool called TOAD, which works with Oracle database in which you can compare two items.
You can use any language, which supports database access and compare the records of the databases.
If your requirement is different, please elobrate.