I found that using BI in SSIS, I can look for duplicate rows and eliminate them while transfer but it is table to table copy. Will take long time to copy 100 of tables. How can I copy DB 1 to DB 2 but ignore those rows that already exist in DB 2. Thanks,Frenk

Hello, You have to go by Table by Table, There is no option that can transfer whole database to New DB and eliminate duplicates too during transfer. thanks http://sqlage.blogspot.com/

I found that using BI in SSIS, I can look for duplicate rows and eliminate them while transfer but it is table to table copy. Will take long time to copy 100 of tables. How can I copy DB 1 to DB 2 but ignore those rows that already exist in DB 2. Thanks, Frenk All answered here: Checking if a row exists and if it does, has it changed? http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me