Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Database compare (Read 2053 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Database compare
01.10.08 at 20:42:05
 
Database compare
 
Tables:
The first thing to do when doing a database compare is to see whether there is a difference in tables in both databases. Usually a database has a means of dumping the table list. In Oracle you can use select * from all_tables. Other databases may have other ways to do this. You can always use the tables list in SQL*XL SQL editor. Selecting all tables and dragging it to the editor area will copy the names into the editor.
 
Data:
To compare whether two tables contain the same information you can use the minus SQL operation. To see which rows in table1 do not exist in table2 you can run:
select * from table1
minus
select * frmo table2
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1