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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-27 : 08:03:21
|
| ashutosh writes "HiMy problem is like I have two different sql servers (both of them are SQL SERVER 2000). Consisting of a database with the same name and same tables in that database. And i want to compare both of these two databases and then I need to keep the uniqe data as it is in the both the servers and I want to create new tables of duplicate rows for server1 and for server 2.i.e. the rows matching of server1 with server2 will be copied in a separate table in server1 and vice a versa server2 records matching with server1 will be copied in a new table in server2.So how to go about this process and what will be the queries.thank you,Ashutosh" |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-10-27 : 09:26:10
|
| There are lots of third party tools available for comparing the Database. SQL Compare from Red Gate is good tool for comparing the databases.Complicated things can be done by simple thinking |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-28 : 07:19:50
|
Hi,1). [url]http://www.adeptsql.com/[/url]2). [url]http://www.dbbalance.com/index.htm[/url]and3). [url]http://www.red-gate.com/products/SQL_Compare/case_studies/comparing_databases.htm[/url] HTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
|
|
|
|
|
|
comparision of two databases on two different servers