All geek questions in one place

How do schema migration tools work?

I have a db based application and I delete the contents of the schema and db every time there is any change in the schema. Now it is in development mode. Soon we will release the application in production. But we suspect that after the release of the application in production use, there may be many changes. The software must be installed in many places around the world. (Not a web application)

How does the schema migration tool work in this case? or How can we use them in typical database applications where we suspect schema changes?

+3
source share
2 answers

Download the RedGate tools and find out. I believe everyone has trial periods, and I'm sure SQL Compare does.

Typically, you point them to two databases and list all the differences between them. You can configure them to ignore certain things, such as comments, constraint names, etc. From there you can choose which elements you want to synchronize and in which direction, and the tool will either generate a script for you, or make changes for you to do this.

, , script, , , , . , , . ( ), .

SQL Data Compare, . , .

, , - , , .

+4

RoundhousE sql.

, . RoundhousE , , , .

, RoundhousE - .

0

Source: https://habr.com/ru/post/1728207/

More articles:


All Articles