Home » SQL & PL/SQL » Client Tools » Help me to find the best tool
Help me to find the best tool [message #428502] Wed, 28 October 2009 09:34 Go to next message
whatisDB
Messages: 2
Registered: October 2009
Junior Member
hello,

I am trying to find a best Tool available in the market that will satisfy the following requirements:

The condensed requirements are as follows:

--> We have a database, lets call it "R2-D2".
--> We have 3 tables that are updated everyday with new information. Lets call all these 3 tables as secondary storage tables.
--> We have another 4 tables which we are going to call "primary tables".
--> The secondary storage tables and primary storage tables have 16 columns in each that have to be compared with each other. In other words 16 columns from 3 tables of secondary storage table have to be compared with 16 columns of the 4 primary storage tables.

Question:
1. Is there a tool to compare data between these tables using a form or a GUI? something that an end user can access to view the information in a comparison form?
2. Once the comparison is done can we either UPDATE or INSERT data from the secondary storage tables to the primary storage tables?


Any help in this regard is greatly appreciated.
Re: Help me to find the best tool [message #428503 is a reply to message #428502] Wed, 28 October 2009 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
FIREFOX & a small matter of programming
Re: Help me to find the best tool [message #428506 is a reply to message #428503] Wed, 28 October 2009 09:45 Go to previous messageGo to next message
whatisDB
Messages: 2
Registered: October 2009
Junior Member
The problem is we dont have a programmer and our budget is less than $500.
Re: Help me to find the best tool [message #428998 is a reply to message #428502] Sat, 31 October 2009 20:29 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hi,

I know that PLSQL Developer have a functionnality to "Compare Table Data". So if your table have the same structure you can use it to do the compare. It can also generate the INSERT,UPDATE, and DELETE if required.

Hope it help.
Re: Help me to find the best tool [message #430498 is a reply to message #428998] Tue, 10 November 2009 13:30 Go to previous messageGo to next message
wvu1999
Messages: 38
Registered: April 2007
Member

Toad for Data Analysts does this very nicely, supports multiple tables from multiple instances, even if on different servers and no need for DB_LINKs. Can also work on tables with different structures.


And it supports XLS, Access, SQL Server, etc in addition to Oracle.

Fits in your budget as well.
Re: Help me to find the best tool [message #430500 is a reply to message #430498] Tue, 10 November 2009 13:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TOAD does many behind the scene and you don't know what.
TOAD locks resources without you know it and may lead to ORA-1555 or "unable to extend" errors in other sessions without speaking those that are blocked because of it.
...

Regards
Michel

[Updated on: Tue, 10 November 2009 13:41]

Report message to a moderator

Re: Help me to find the best tool [message #430503 is a reply to message #430500] Tue, 10 November 2009 14:03 Go to previous messageGo to next message
wvu1999
Messages: 38
Registered: April 2007
Member

If you ask to change something, Oracle's going to lock the object appropriately. No differently than issuing an UPDATE via SQL*Plus.


If you don't understand transactions in oracle, you can always make Toad 'Read Only'.
Re: Help me to find the best tool [message #430559 is a reply to message #430503] Wed, 11 November 2009 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The point is not understanding or not transaction, it is the fact that TOAD do some things behind the scene WITHOUT telling what it does and LOCKS some resource without you know it because you don't know what it does.

If you use SQL*Plus, you know what it does because SQL*Plus does not do anything you don't tell it to do.

Regards
Michel
Re: Help me to find the best tool [message #430600 is a reply to message #430559] Wed, 11 November 2009 02:57 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Wed, 11 November 2009 08:05
If you use SQL*Plus, you know what it does because SQL*Plus does not do anything you don't tell it to do.

I think it is about time to face reality here. People want to and will use graphical tools to do database access.
You can not and should not expect everyone to use sqlplus.

Having said that, tools should clearly document what behaviour is to be expected (in your case, when it will lock what)
Re: Help me to find the best tool [message #430640 is a reply to message #430600] Wed, 11 November 2009 06:11 Go to previous message
wvu1999
Messages: 38
Registered: April 2007
Member

If you click in a 'live' data grid, i.e. one that is setup for editing, Toad can place a row-level lock.

You can avoid this several ways. Best is to use option to default to Read Only data grids.

You can always see what Toad is doing with the Database > Spool SQL to Screen option.

Somehow we got off topic, my original answer was to look at Toad for Data Analysts, which has a completely different transaction architecture than Toad for Oracle and comments around the 'mystery locks' do NOT apply.
Previous Topic: TOAD 8.6 on Windows 7
Next Topic: isqlplus not starting
Goto Forum:
  


Current Time: Wed Dec 07 06:56:14 CST 2016

Total time taken to generate the page: 0.12359 seconds