How to compare two databases in separate SQL servers and generate the SQL scripts


I have used a software called :”AdeptSQL Diff” to compare two databases from different SQL servers. It shows the tables, stored procedures, functions and other items one by one very clearly. From this software it is easy to compare the two databases and get to know what are the items available in one database and what are the items not available. We can also generate the scripts to make the two databases same by tables/stored procedures/functions/users. It is a very good software to even do modifications and run the scripts from there. From that software we can easily make the two databases same.

No comments: