Copying 1 table to training DB

gkrenton · Jun 2, 2007

I have a table that I resides in my live DB but not in my test DB. I can't figure out what the sql syntax would be to copy the table from the one instance to the other.

MS Sql looks like it would be something like this

insert into ol_rentontrain.atb.ren_custom_tran
select * ol_renton.atb.ren_custom_tran

but not working in informix.

Any suggestions would be appreciated.

thanks

gina

gumbie · Jun 4, 2007

Hi Gina,

It's been a while since I've worked with Informix however I believe the following will work:

INSERT into remote_db@IDS_server_name:table_name
SELECT * from local_table_name;

HTH

Cheers,
-gumbie.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Copying 1 table to training DB

gkrenton

MIS

gumbie

Technical User

Similar threads

Part and Inventory Search

Sponsor