Take the 2-minute tour ×  i know this should be db 101, but its
just not as clear as it can be for me. I am using SQL2005
express and i want to copy data from databaseA to databaseB.
DatabaseB already contains existing data - it may even contain
data with pk's that have changed or dont exist - for example:
DataBase A pk1 = peaches pk2 = apples  DataBase B pk1 = peaches
pk2 = oranges pk3 = apples  now both A & B have related tables
that are tied to the pk.  Historically i would write an app that
selects the data from A and copies it to B via its Insert/Update
procs (using .NET), but obv this is very cumbersome, tho some
advantages are i could have a dropdown that allows you to select
A to copy - and B to copy to if it exists, or say add new - for
instance:  (dropdown - select source) Peaches Apples  (dropdown
- select target) -new- peaches oranges apples  I was going to
use SSIS, but the target db has only SQL express so this is not
available nor do i have time to learn it (ive used dts much in
the past, but