Oracle to Oracle:
insert into productiondb.bill_detail select * from backupdb.bill_detailThis query will copy everything that is missing back into the production DB.
where not exists
where bill_id = backupdb.bill_detail.bill_id)
MSSQL to MSSQL:
Here's how I populated nd_loc and it took only 10 or so seconds to copy ~150,000 rows! First connect to the production db and then create the link to the backup server. By running the command "sp_addlinkedserver sqldev" (where sqldev is the other server name where the backup db is. You don't have to do this if both db are on the same server)
insert into nd_loc select * from sqldev.backupdb.dbo.nd_loc
Now why can't their damned odbc driver be that fast? (Thanks Scott for the tips)