Red Gate forums: Data Compare for Oracle EAP

RE: Unable to Download the EAP

alice.easey — Thu, 09 Dec 2010 14:42:13 GMT

Hello,

You can download a zip of the exe from here:

Hope this helps!

Alice.

Unable to Download the EAP

pourm — Wed, 08 Dec 2010 10:25:50 GMT

Hi
We have firewall which does not allow download of .exe. Is there a way that we can download a zip version

RE: Strange behaviour in 1.0.1.224

neil.anderson — Thu, 25 Nov 2010 16:43:36 GMT

Hi James,

Thanks for the steps, we have been able to reproduce and fix the sync direction bug you found.

We have also fixed the warning bug.

You are right, an error like that should not crash Data Compare. We will investigate handling that one more gracefully.

We will have a new build ready soon with these changes.

Thank you for trying the tool and giving us your feedback,
Neil

RE: Strange behaviour in 1.0.1.224

jspibey — Thu, 25 Nov 2010 13:07:04 GMT

Hi Neil,

I have managed to reproduce the issue with the following steps

1. Open data compare and select my destination on the left and my source on the right and the 'compare to' arrow pointing towards the left (Yellow Background).

2. Run comparison

3. Run Synchroinisation Wizard, then select Next to view synchronisation script.

4. In the window, the generated SQL is referring to updating my Source database even though the direction of update is to my destination (i.e. database scripts say 'UPDATE SOURCE SET Blah ' when they are actually to be executed on the destination

Any yes I understand the crash was due to insufficient privilleges but should that have crashed Data Compare?

Thanks

James

RE: Strange behaviour in 1.0.1.224

neil.anderson — Thu, 25 Nov 2010 11:54:11 GMT

Hi James,

Thanks for testing Data Compare and for giving us this information. We are investigating the issues you reported.

Can you tell us what you mean by "the information there suggests that the actual synchronisation hasn't been reversed."? Is that information the script, the warnings or the summary?

Your second post gives an Oracle error ORA-010301: insufficient privileges which suggests that the user you are logged in as on the target does not have permission to update the table "TWEBSITE"."ACCESS_REQUESTS".

Thanks,
Neil

RE: Strange behaviour in 1.0.1.224

jspibey — Wed, 24 Nov 2010 16:32:07 GMT

And I also just generated a crash

Bug report generated at 24/11/2010 16:31:30
Program version 1.0.1.224

System.Exception: When synchronising couldn't execute the statement:
DECLARE
null_value CHAR(1) := NULL;
statement1 CHAR(103);
BEGIN
statement1 := 'INSERT INTO "TWEBSITE"."ACCESS_REQUESTS" (USERNAME,ROLENAME,DATE_APPLIED,NOTES) VALUES (:0, :1, :2, :3)';
EXECUTE IMMEDIATE statement1 USING 'aparr', 'scg', TO_DATE('29/OCT/2010AD 18:21:27','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'areed', 'kpi', TO_DATE('21/JUL/2010AD 13:05:20','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'awarry', 'bi_employees', TO_DATE('23/NOV/2010AD 10:41:27','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'awarry', 'scg', TO_DATE('23/NOV/2010AD 10:41:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'carmel occhini', 'bi_bsa', TO_DATE('16/NOV/2010AD 10:32:10','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'carmel occhini', 'kpi', TO_DATE('16/NOV/2010AD 10:32:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'clittlejohn', 'bi_bsa', TO_DATE('23/JUN/2010AD 16:30:21','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'cxgraham', 'bridgwater', TO_DATE('15/NOV/2010AD 12:50:51','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'dawn webster', 'scg', TO_DATE('12/AUG/2010AD 13:52:40','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'eblackwell', 'bi_bsa', TO_DATE('22/NOV/2010AD 11:34:50','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'eblackwell', 'bi_employees', TO_DATE('28/OCT/2010AD 11:05:28','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'guisey', 'kpi', TO_DATE('29/JUL/2010AD 13:04:08','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'bi_customers', TO_DATE('26/MAY/2010AD 16:55:05','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'salesdb_confed', TO_DATE('26/MAY/2010AD 17:04:00','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'jeffnagy', 'scg', TO_DATE('26/MAY/2010AD 17:06:35','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'jtownsend1701', 'bi_bsa', TO_DATE('12/NOV/2010AD 16:24:28','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'jtownsend1701', 'kpi', TO_DATE('12/NOV/2010AD 16:25:17','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'karencullen', 'bi_bsa', TO_DATE('17/NOV/2010AD 11:16:30','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'kaujla', 'bi_customers', TO_DATE('26/MAY/2010AD 18:20:42','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'bi_customers', TO_DATE('15/NOV/2010AD 12:48:46','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'bi_employees', TO_DATE('15/NOV/2010AD 12:45:50','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'kwhittle', 'kpi', TO_DATE('15/NOV/2010AD 12:48:33','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'kwright', 'bi_bsa', TO_DATE('12/NOV/2010AD 14:30:51','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'michalafoott', 'kpi', TO_DATE('08/NOV/2010AD 09:32:56','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_bsa', TO_DATE('26/OCT/2010AD 15:49:56','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_customers', TO_DATE('26/OCT/2010AD 15:50:03','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mmcclue', 'bi_employees', TO_DATE('26/OCT/2010AD 15:49:34','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'bi_customers', TO_DATE('24/AUG/2010AD 15:31:26','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'rangemanagement', TO_DATE('24/AUG/2010AD 15:32:08','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'mwinslet', 'scg', TO_DATE('24/AUG/2010AD 15:31:38','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'pway', 'bi_employees', TO_DATE('22/NOV/2010AD 12:12:01','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'pway', 'rangemanagement', TO_DATE('22/NOV/2010AD 12:14:41','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
EXECUTE IMMEDIATE statement1 USING 'rhullafont', 'dc_kpi', TO_DATE('24/JUN/2010AD 09:15:09','DD/MON/YYYYBC HH24:MI:SS', 'nls_date_language=ENGLISH'), null_value;
END;
---> Devart.Data.Oracle.OracleException: ORA-01031: insufficient privileges
ORA-06512: at line 6
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.an.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at RedGate.Oracle.Common.OracleStatementExecutor.Execute()
--- End of inner exception stack trace ---
at RedGate.Oracle.Common.OracleStatementExecutor.Execute()
at RedGate.Oracle.Compare.EngineController.Data.DataCompareEngine.#t.#O3c.#w0X()
at RedGate.Shared.Controls.ProgressDialogEx.e()

Strange behaviour in 1.0.1.224

jspibey — Wed, 24 Nov 2010 16:30:12 GMT

Hi,

I'm currently testing out DC for Oracle v1.0.1.224 64Bit on Windows 7 and I've had a few strange things happen

- After performing a comparison, click on the 'Edit Project' -> 'Tables' and I get the error 'The schema MYSCHEMA does not exist in the database'. Obviously it does exist otherwise I wouldn't have been able to do the initial comparison

- When I've done a comparison, I double-click the Direction arrow between the two hosts to indicate I want to reverse the comparison. The UI changes but when I click Synchronise, the information there suggests that the actual synchronisation hasn't been reversed.

- I get a warning about a column mapping error (VARCHAR column size difference) but this is in the wrong direction and also shown for a table which hasn't been included in the synchronisation

Thanks

James

Data Compare for Oracle Release Candidate now available

alice.easey — Thu, 18 Nov 2010 08:45:45 GMT

The release candidate of Data Compare for Oracle is now available for download:
http://www.red-gate.com/products/data_compare_for_oracle_eap/index.htm

What's new?
* 9i support
* Synchronization performance increased by 10x
* Numerous bug fixes including
- Increased support for Unicode
- Scripting out larger LOBs
- Handling invalid data more gracefully

We're hoping to release v1.0 in December. If you have any feedback or comments we'd love to hear them.

RE: Date Related Error

neil.anderson — Mon, 15 Nov 2010 12:24:32 GMT

Hi Dave,

Thanks for sending this bug report. We think we have fixed this issue in the latest EAP available at :

http://downloads.red-gate.com/EAP/DataCompareForOracle/RedGateToolsForOracle.exe

Please give it a go and let us know how you get on.

Thanks,
Neil

Date Related Error

dhart — Fri, 12 Nov 2010 15:43:56 GMT

Hi All,
I received this error when doing a data compare.

Thanks,
Dave

Bug report generated at 11/12/2010 10:38:14 AM
Program version 1.0.0.317

System.ArgumentException: Month is out of range.
Parameter name: month
at Devart.Data.Oracle.OracleDate..ctor(Int32 year, Int32 month, Int32 day, Int32 hour, Int32 minute, Int32 second)
at #3HJ.#7HJ.#KPK(BinaryReader reader, OracleType oracleType)
at #3HJ.#7HJ.#DIJ(BinaryReader reader)
at #3HJ.#YUd.#Qeo(Int32 index)
at #3HJ.#WVJ.GetRows(Int32 rowIndex, Int32 count)
at RedGate.Oracle.DataCompare.RowComparisonResultView.GetRows(Int32 rowIndex, Int32 count)
at #TQK.#WQK.#jAJ(Int32 rowIndex)
at #lsJ.#LsJ.#pyJ()
at #lsJ.#LsJ.#vl(#WtJ dataDifferenceRow, #iuJ rowLevelSelection, #juJ rt, Boolean pivotView)
at #lsJ.#ytJ.#vl(#WtJ dataDifferenceRow, #iuJ rls, Boolean directionChange, Boolean forceRepopulate)
at #lsJ.#ksJ.#HgD(#WtJ d)
at #lsJ.#ksJ.#1lw(#pbD e)
at #18C.#sMc.#t.#tMc.#Jq(T message)
at #18C.#sMc.#Jq[T](T message)
at #BsJ.#DcD.#pjD(#Z8C differenceRow, String columnName)
at #E9C.#duJ.#QUc()
at #E9C.#duJ.#NUc()
at #E9C.#duJ.#i5b(String findPhrase)
at #E9C.#duJ.#FwJ()
at #HcD.#RcD.#FwJ()
at #BsJ.#DcD.#FwJ()
at #3QK.#4QK.#6Lk(#kGr currentProject, #IcE c)
at #BsJ.#5QK.#ZjD(Object sender, CancelEventArgs e, Predicate`1 updateProject, DataProject project, Boolean isDifferentProject)
at #BsJ.#5QK.#t.#izb.#ryD(Object s, CancelEventArgs e)
at System.Windows.Forms.Form.OnClosing(CancelEventArgs e)
at System.Windows.Forms.Form.CheckCloseDialog(Boolean closingOnly)

RE: bug report: capitals

Tom Harris — Fri, 22 Oct 2010 11:50:35 GMT

Hi there,

we believe that we have fixed this issue. You can upgrade to the latest build via

http://downloads.red-gate.com/DeploymentSuiteForOracle.exe

Do let us know how you get on?

Regards, Tom

RE: bug report: capitals

neil.anderson — Thu, 21 Oct 2010 16:20:14 GMT

Hi Martijn,

Thanks for reporting this to us. You are not doing something stupid, it is a bug in the EAP. We will fix it asap and have a new build for you soon.

Regards,
Neil

bug report: capitals

mmo — Thu, 21 Oct 2010 15:59:15 GMT

Hi Support,

I get following error from the Data compare for Oracle. The tool looks promising for my goal, but there seem to be some quotation marks missing. (yes, the name of the column is "Key_SITE")

Or am i doing something stupid?

Best regards,
Martijn Mooij

Bug report generated at 21-10-2010 17:44:12
Program version 1.0.0.318

System.Exception: Couldn't execute statement:
SELECT Key_SITE, Key_MAJOR, Key_MINOR FROM "PAS_STORAGE_MIGRATION"."Q_FILTER" ORDER BY Key_SITE, Key_MAJOR, Key_MINOR ---> Devart.Data.Oracle.OracleException: ORA-00904: "KEY_MINOR": ongeldige ID
at Devart.Data.Oracle.bp.b(Int32 A_0)
at Devart.Data.Oracle.ap.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
--- End of inner exception stack trace ---
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.OracleDBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.DataComparer.Compare()
at #IQK.#HQK.#t.#2Db.#jeR()
at RedGate.Shared.Controls.ProgressDialogEx.e()

RE: OutOfMemory exception

Tom Harris — Fri, 15 Oct 2010 13:24:11 GMT

Ho Johannes,

we have fixed this issue and refreshed the EAP. You can download the installer from http://downloads.red-gate.com/EAP/DataCompareForOracle/RedGateToolsForOracle.exe

Do let us know if the problem occurs again?

Kind regards, Tom

RE: What is the default comparison behavior when there is no key

jeggers — Wed, 13 Oct 2010 15:23:00 GMT

I don't know if I have "a lot" of tables without a PK, I just know I have more tables than I like where no automatic comparison key was selected (and by the way, if I create a custom comparison key, does that get saved with the project?).

What I meant with "quick way of setting all columns" is something like this: I have a list of 500 tables on the existing Tables & Views tab, and let's say 50 of those don't have a comparison key. I want to be able to press a button, it shows me the 50 "problem" tables in a dialog (checked listbox, one item per table, checked by default). In there, I have a button that says "Match on all columns" (and possibly something fancier, see below). If I click on it, it will generate comparison-keys for all checked tables, with those comparison keys including ALL columns of the table. Alternatively, have a way of making it pick a table's unique key as the comparison key for all tables in that dialog.

As for the comparison key that is picked by default: I'm not sure I agree that the PK is always (or even often) the right one, there's plenty of people that use a single numeric column as the physical primary key, whereas the logical primary key is usually much wider (and expressed as a unique key, usually the widest unique key on the table).

In the Table & Views tab, the first column (Comparison Key) shows the name of the comparison key (defaulted to PK) but when I drop down on that column in the grid, it shows me all sorts of columns of that table in the popped up grid even when I don't have Custom selected. It's not really clear why it show columns that are not in the selected non-custom key.

Also... Can we have an option to exclude temporary tables from the Table & Views display? I don't see how those could have data in them (unless Data Compare also compares structures).

Also, can we have an option to exclude SYS_IOT tables from the Table & Views display?

Also... When it picks PKs as the default comparison key, does it do so based on the columns in the PK, or just the fact that they are the primary key? Or that they have the same name?

I also find the name "Comparison Key" confusing, certainly when I look at the rightmost grid column called "Columns in Comparison". My understanding is that the comparison key is used to find matching rows, whereas Columns In Comparison are the columns that are actually compared. If that understanding is correct, shouldn't "Comparison Key" be "Matching Key" ?

What happens if there is more than one row in one database matching a single row in another database?

Once I have everything configured (my keys, my options, my list of tables to compare)... I need to be able to save that as part of my project, so if I open the project again I don't have to configure everything again.

Sorry for mixing everything into a single topic

Tom Harris wrote:

Hi Johannes,

good question. You are correct that if there is no primary key or unique constraint then no default will be set. We need some unique way of matching up records. I'm not sure I follow your request for quickly setting all columns - how would this work?

Do you have lots of tables that do not have a primary key, or unique constraint. If so, is there an obvious 'index' that could be used? If so use this as a custom way of comparing records.

Do reply if I'm not getting your point?

Kind regards, Tom