SQLTeam.com | Weblogs | Forums

Database Migration using SSIS


Hi All,

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.



Continuing the discussion from If it exists, update it; if not, create it:


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.