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.
While you may be able to keep the databases in sync using SSIS, from what you have described, my sense is that replication might be a more suitable tool for this requirement.