I am having 2 database.
DB_A and DB_B are the 2 database.
Now I want to migrate data from DB_A to DB_B.
I am having 500 tables in both database.I want to to migrate the database in a such a way that If records are new it should be inserted or if exist it should be updated.
Please suggest me if we can achieve using SSIS.