Select from dbsource.table1 and insert dbtarget.table

[ssafavi]

I have two databases with identical tables.
I would like to select from one and insert into the other.
Since they are identical it would be a waste to select from
dbsource.table1 loop through the resultset and prepare the insert
statement into dbtarget.table1. Especially for a data transfer
activity.

Do you know any smart way of doing this?
Thanks

 

[Lee Fesperman]

I have two databases with identical tables.
I would like to select from one and insert into the other.
Since they are identical it would be a waste to select from
dbsource.table1 loop through the resultset and prepare the insert
statement into dbtarget.table1. Especially for a data transfer
activity.

Do you know any smart way of doing this?
Thanks

You didn't mention the DBMS you are using, but most support INSERT using a SELECT. For
example (assuming the two tables have identical columns, and they are defined in the
same order),

INSERT INTO target_table SELECT * FROM source_table

Check the docs for your DBMS.