var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: copying table from 1 db to another
I have a 'live' & 'test' version of the same db. One called
live & one called test.
I have a table on the live side that I need to copy over to the 'test' side.
For the life of me I can't figure out the informix sql sytax.
create table ol_train.ren_option_invite as select * from ol_live.ren_option_invite
where ol_live is the naming convention of the live db instance & ol_train isthe name of the training environment. Seems like this should work but nope it doesn't.
I'm obviously missing something obvious but have no idea what it is.
Thank you in advance.
what about onunload and onload, have to be the same DB-Version.
onunload -t table.onu ol.livewner.table_name
load back in the second DB
onload -t table.onu ol.trainwner.table_name
Different ways to do this & it's been a while since I've done this, previous example using unload and load works well.
To do this in a single step, I think you must specify the DB name@instance namewner of the DB in single quotes.table name of the table you're selecting data from.
This assumes the target table in the test DB already exists and whatever SQL tool you're using is accessing the testDB.
Example: insert into ren_option_invite
select * from live@prod-instance:'sysadm'.ren_option_invite
that points me in the right direction.