CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2008comparison
Sam P
Sam P

Reputation: 515

What are the alternatives to TableDiff utility on SQL Server 2008?

Currently we are using the TableDiff utility during an SSIS data load to update a live table in production from a staging table (which has the latest data to be updated - could be insert/update/delete).

But TableDiff takes quite a bit of time to identify differences and create the sql scripts for the job to use to update (from few hours - to indentify about a few 1000s of rows of updates to few 100,000s of rows of updates taking up to a few days).

Are there any better alternatives to TableDiff utility on SQL Server 2008 or maybe better processes/ideas?

Update: Looking for both product/utility options as well as better algorithms to make it faster

Upvotes: 3

Views: 2454

Answers (3)

satcat66
satcat66

Reputation: 116

Why calling a stored procedure with a MERGE statement in it is not an option here? I was using this approach in my DTS days.

Upvotes: 2

Diego
Diego

Reputation: 36176

RedGate supposedly is the best.

I sometimes use Atlantis tools

They are quite heavy, but do their job

Upvotes: 0

Fedor Hajdu
Fedor Hajdu

Reputation: 4695

I'd suggest Red-Gate's SQL Data Compare but it's a bit pricey. (there's a free trial if you want to check it out if it works for you)

Upvotes: 1

Related Questions