Very useful discussion on this partial data recovery.

question:

1. Is there any method in recovering partial, ex 2 tables out of 400 tables 20 gb db?

I still miss the old SQL6.5. I don't think it is available in SQL2000 and SQL2005. how about SQL2008?

2. SQL Data Compare Pro is definitely a good tool in helping the recovery.

I also use SQL Compare Pro. it is a good tool in catching the difference.

But it is very poor in export, ex. to xls with details. I could view them when drilling down on one item, but not export them, any idea?

thanks

-D