Very useful discussion on this partial data recovery.
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?