Need column names in Insert statements

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Need column names in Insert statements

Postby prabhubravo » Tue Jul 29, 2014 4:23 am

Hi,
I use Data compare for oracle. The tool works fine comparing the tables but when I generate the sqls for the differences, the insert statements doesnot have an explicit column name in the insert statements. This causes errors when I run the scripts into another database, as the column order for that table in that new database might not be same as the target database to which I compared to.
Is there an option to include the column names in the scripts?
[u]process followed:[/u]
Compare Db1 and Db2, generate sqls for the difference that is then run on Db3. (We cannot access Db3 to do the comparison)

[u]Script generated by Red Gate:[/u]

statement1 := 'INSERT INTO position VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)';
EXECUTE IMMEDIATE statement1 USING value0, value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, value11;

When I run this sql in a different database, the same table 'position' has a different ordering of columns.


Thanks
Last edited by prabhubravo on Tue Jul 29, 2014 9:41 pm, edited 1 time in total.
prabhubravo
 
Posts: 4
Joined: Tue Jul 29, 2014 3:56 am

Postby richardjm » Tue Jul 29, 2014 7:31 am

Nice idea, and having a quick look at it this morning (pre-coffee) I've implemented the option.

This should make it into the next release which I hope will be in the next few weeks. If you need it more urgently you can contact support@red-gate.com to get the latest build.

What a great way to start the morning, that's really cheered me up after all my LDAP woes yesterday, thanks.
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 395
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd

Postby prabhubravo » Tue Jul 29, 2014 9:45 pm

Excellent !! that was quick turn around. I have emailed the support team to get me the latest build.

Regards,
Prabhu
prabhubravo
 
Posts: 4
Joined: Tue Jul 29, 2014 3:56 am

Postby richardjm » Wed Jul 30, 2014 7:17 am

Happy to help :)
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 395
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 1 guest