Data Compare Redgate
I’m using Redgate Data Compare for Oracle 5. I’ve (successfully) created Source and Target connections (both Oracle 11g), defined schema names on both side, then switched to 'Tables & Views' tab. There was Initializing process popped-up, like connecting to db, populating metadata from oracle tables etc. and get list of tables from both connections. Later, I switched back to “main” screen 'Data Sources' and changed one of the connections to another database (Oracle 12c). This time 'Tables and Views' initialization failed with bunch of ORA errors.
Apr 16, 2016 This demo will train you on how to use the Redgate Developer Bundle tools - SQL Compare and Data Compare. It will even show you how to pull records out of a BAK and create deployment documentation. ApexSQL Data Diff 2012 vs. RedGate® SQL Data Compare 10 performance comparison Performance is a critical factor for our customers. Therefore we run performance tests as a part of our ongoing performance improvement efforts.
ORA-19202: Error occurred in XML processing
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file PSImetalsParameters.csv in TEST not found
ORA-06512: at 'SYS.DBMS_XMLGEN', line 288
ORA-06512: at 'SYS.DBMS_XMLGEN', line 237
ORA-06512: at 'SYS.DBMS_XMLGEN', line 280
ORA-06512: at line 1
(I have doubt that it may be some privileges issue for that user/schema. But not sure which Oracle tables or schemas RedGate needs to access.)
Any help on it?
Browse other questions tagged oracleredgatered-gate-data-compare or ask your own question.
Redgate Sql Data Compare 13
I have been using SQL Compare by Redgate at my company and was very satisfied with it. Are there any free comparison tools that are similar? Or what would be my best shot for synchronizing two SQL db's without a paid application
closed as not constructive by Bill the LizardDec 17 '12 at 13:59
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
8 Answers
I’ve gone through this and couldn’t find anything comparable, free or otherwise. $395 is a very small price to pay for the value the tool brings and it will almost certainly pay for itself very quickly in productivity gains and risk minimisation.
Data Compare For Oracle Redgate
I had the same problem and wanted a free GUI base Schema comparer tool, what I found wasStar Inix (http://www.starinix.com/sqlcompare02.htm). Obviously not as good as Redgates offering, but it does the job.
Also, with Redgate Sql Compare, once the trial period is over, if you enter the key as 'i need more time' (without the quotes) you can extend the trial by a further 14 days.
Redgate Sql Search Free Download
Visual Studio (Premium & above I guess) has this feature built-in under the SQL menu.
Very similar to RedGate's SQL Compare and free.
You can try using TableDiff , that came with SQL Server 2005.
Bye.
Have a look at Mighty Comparer. It's currently free. A professional version is under development.
I normally go for the hackish but surprisingly effective technique of downloading the sys_information tables to text files and diffing them with your favorite diff program (this way will even let you compare 3 schemas!).
You can use Database Comparer
Database Comparer is free for non-commercial use.