Red Gate forums :: View topic - Need column names in Insert statements
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Data Compare for Oracle
Data Compare for Oracle forum

Need column names in Insert statements

Search in Data Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
prabhubravo



Joined: 29 Jul 2014
Posts: 4

PostPosted: Tue Jul 29, 2014 4:23 am    Post subject: Need column names in Insert statements Reply with quote

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
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 395
Location: Red Gate Software Ltd

PostPosted: Tue Jul 29, 2014 7:31 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
prabhubravo



Joined: 29 Jul 2014
Posts: 4

PostPosted: Tue Jul 29, 2014 9:45 pm    Post subject: Reply with quote

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

Regards,
Prabhu
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 395
Location: Red Gate Software Ltd

PostPosted: Wed Jul 30, 2014 7:17 am    Post subject: Reply with quote

Happy to help Smile
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group