Feature-Request

[l.pohlmann]

This is something that generates work for me, which wouldn't be necessary:

We have a development-DB and a live-DB. I often create data on the development-DB which I want to transfer to the live-DB en bloc. This isn't necesarrily a lot of data, but spans over multiple tables. Which makes export-import too work-intensive.

Here's my feature-request:
It would be great to have the possibility to generate "INSERT" - Statements from "SELECT"-Statements. I could then compile a script
for the live-DB to insert all the necessary data in one turn.

Of course this wouldn't work with blobs, but it wouldn't be necessary.

I know I can do it with Export->SQL Inserts, but then I would have to save the data for every Export in seperate Files, would have to be sure or double-check the where-clause, and would have to open all those files again and compile the "INSERT"-Statements...

I'm just wishing for a better workflow in such cases...

You see what I mean?

 

[Marco Kalter]

Can you provide a little example of this select-to-insert conversion? I'm not sure if I understand.

 

[ScottMattes]

Someone, Mike I think, just shared some test window code to do this (create insert statements based on a select statement).

This is the thread, look at the last entry http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002264

 

[l.pohlmann]

Yes, that was exactly what I'm looking for. Though and easy right-click feature would be nice as well.

 

[Joachim Rupik]

Though and easy right-click feature would be nice as well.

If you use BE (Browser Extender) it will be easy right-click feature.

Joachim Rupik

 

[King Finger]

Hi,

simply create a DB-Link and execute your queries
as normal.

insert/*+append*/ into ...
select ... from ...@livedb

it is as simple as that.

regards

 

[whip]

Just for the record: the script is originally my work and a formatted version can also be found at

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=001632

Cheers,
whip

 

[mike]

Thanks Whip - I was hoping you would speak up. I couldn't remember who wrote it and it's pretty darned cool.

Mike

 

[BushPilot]

What do I do in our environment....??? Being a BANK...the Auditors do not allow datbaselink between DEV and TEST and PRODUCTION.....
??????????