Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-07-02 : 12:44:08
|
| Hi!I want to compare the two database and see what is the extra data or difference between. How can I do that????Thank You very much! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-02 : 12:47:54
|
| Take a look at SQL Data Compare by Red-Gate:[url]http://www.red-gate.com/sql_tools.htm[/url]BTW, are you going to do this on ALL of the tables or just a few. Either way it could cause a performance problem, so you might want to do this in a maintenance window if this is production we're talking about.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-02 : 12:48:55
|
| If you can't afford to purchase the above product or are looking for a different approach:[url]http://www.sqlteam.com/item.asp?ItemID=7269[/url]Tara |
|
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-07-02 : 13:15:58
|
| Thanks!!!! great help |
|
|
|
|
|
|
compare two databases