SQLTeam.com | Weblogs | Forums

Database Migration using SSIS


#1

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.

Regards,
Rambabu


#2

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


#3

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.