| COUNTRY | ||
| CURRENCY | ||
| Australia | ADollar | |
| Austria | Schilling | |
| Belgium | BFranc | |
| Canada | CdnDlr | |
| England | Pound | |
| Fiji | FDollar | |
| France | Euro | |
| FFranc | ||
| Germany | Euro | |
| D-Mark | ||
| Hong Kong | HKDollar | |
| Italy | Euro | |
| Lira | ||
| Japan | Yen | |
| Netherlands | Guilder | |
| Switzerland | SFranc | |
| USA | Dollar | |
| Same: 10, Different: 3, Missing: 0, Extra: 1. | ||
| DEPARTMENT | |||||||
| DEPARTMENT | DEPT_NO | HEAD_DEPT | LOCATION | MNGR_NO | PHONE_NO | ||
| NULL | Corporate Headquarters | 000 | NULL | Monterey | 105 | (408) 555-1234 | |
| NULL | Sales and Marketing | 100 | 000 | San Francisco | 85 | (415) 555-1234 | |
| NULL | Pacific Rim Headquarters | 110 | 100 | Kuaui | 34 | (808) 555-1234 | |
| NULL | Field Office: Japan | 115 | 110 | Tokyo | 118 | 3 5350 0901 | |
| NULL | Field Office: Singapore | 116 | 110 | Singapore | NULL | 3 55 1234 | |
| NULL | European Headquarters | 120 | 100 | London | 36 | 71 235-4400 | |
| NULL | Field Office: Switzerland | 121 | 120 | Zurich | 141 | 1 211 7767 | |
| NULL | Field Office: France | 123 | 120 | Cannes | 134 | 58 68 11 12 | |
| NULL | Field Office: Italy | 125 | 120 | Milan | 121 | 2 430 39 39 | |
| NULL | Field Office: East Coast | 130 | 100 | Boston | 11 | (617) 555-1234 | |
| NULL | Field Office: Canada | 140 | 100 | Toronto | 72 | (416) 677-1000 | |
| NULL | Marketing | 180 | 100 | San Francisco | NULL | (415) 555-1234 | |
| NULL | Engineering | 600 | 000 | Monterey | 2 | (408) 555-1234 | |
| NULL | Software Products Div. | 620 | 600 | Monterey | NULL | (408) 555-1234 | |
| NULL | Software Development | 621 | 620 | Monterey | NULL | (408) 555-1234 | |
| NULL | Quality Assurance | 622 | 620 | Monterey | 9 | (408) 555-1234 | |
| NULL | Customer Support | 623 | 620 | Monterey | 15 | (408) 555-1234 | |
| NULL | Consumer Electronics Div. | 670 | 600 | Burlington, VT | 107 | (802) 555-1234 | |
| NULL | Research and Development | 671 | 670 | Burlington, VT | 20 | (802) 555-1234 | |
| NULL | Customer Services | 672 | 670 | Burlington, VT | 94 | (802) 555-1234 | |
| NULL | Finance | 900 | 000 | Monterey | 46 | (408) 555-1234 | |
| Same: 11, Different: 0, Missing: 10, Extra: 0. | |||||||
| | Same records. | This document was generated with FBCopy tool. | |
| | Different records, value found in sysdba@:/opt/firebird/examples/employee.fdb. | ||
| | Different records, value found in sysdba@:test.fdb. | ||
| | Missing - Records not found in sysdba@:test.fdb. | ||
| | Extra - Records not found in sysdba@:/opt/firebird/examples/employee.fdb. |