3 ms·
Even if you do know SQL syntax using the tool to make the change script for you can save quite a bit of time, especially if you've made a bunch of changes which
by bartread 8y ago
Even if you do know SQL syntax using the tool to make the change script for you can save quite a bit of time, especially if you've made a bunch of changes which can happen if you've added new functionality.
DISCLAIMER: I worked at Redgate, who make a tool called SQL Compare that works with SQL Server, for nearly a decade. Since this article is about PostgreSQL you should check out Postgres Compare, built by my friend Neil: https://www.postgrescompare.com/ https://www.postgrescompare.com/. He also used to work at Redgate.
- postgrescompare 8y agoThanks Bart! I know for PostgresCompare a lot of its utility is in finding the differences. Providing clarity into what has changed while one was building a feature. A lot of users still write the SQL themselves. They let the tool figure out the easy stuff, get the dependencies correct, and they make a few edits here or there.