How do I compare two database schemas in SQL Server 2008?
14 views
Skip to first unread message
Jennifer Patterson
unread,
Feb 25, 2023, 12:42:11 PM2/25/23
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Databases
How do I compare two database schemas in SQL Server 2008?
George Murphy
unread,
Feb 25, 2023, 1:35:05 PM2/25/23
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Databases
If you’re using Visual Studio, your best option would be to add SQL Server Data Tools to compare two different database schemas. RedGate SQL Compare is another good option. There are other tools which can do this, but these would be my first choices.
суббота, 25 февраля 2023 г. в 19:42:11 UTC+2, Jennifer Patterson:
Wesley Greer
unread,
Mar 5, 2023, 8:10:57 AM3/5/23
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Databases
You can use database comparison tools and it will help you automate the process, which is more reliable than manual work. A list of the best tools for compare sql server databases can be found in this article. It covers both free programs and more advanced paid versions with a trial period. You'll also find helpful tips here and what data comparison tools should do.
субота, 25 лютого 2023 р. о 20:35:05 UTC+2 George Murphy пише: