Is there any SVN for database?

Asked

Viewed 88 times

3

I have the following environment, an online database (Mysql) for production and several others (copies for each developer) used for local testing.

Is there any program as well as SVN that performs the structure copy without the database data?

It would be a way to control the versions and changes of the database as well as update the structure of the Slaves.

How is this process?

mysql database versioning replication

  • There is, the SVN..

  • @Maniero Vc refers to checking out the date folder, where is the database data, that? if that’s the case I believe would overwrite the data, it may harm the local environment that already has test information.

  • just keep the structure? Workbench export tool does not serve?

1 answer

3


There is, SVN. You can also use Git and other normal versioning tools. The structure of DB is expressed by a text with a code we call DDL (Data Definition Language) where the command CREATE TABLE is the most used. Then you do the versioning like any other code. Note that you will only control the structures and not the data. Remembering that copying the structure without the data is DBA’s task and something extremely simple to do, does not need tool, just know how to use the database you are using.

There are technologies used in conjunction with languages that have a mechanism of Migration and some may help in versioning itself.

Has a article by Martin Fowler about it. It also has a post of Jeff Atwood that gives tips to follow. Other interesting article.

There are specific tools, but in general they are not necessary. It has a list of them. When the person cannot organize they end up being useful by being part of the work.

  • Thanks @Maniero, these articles have given a good help to better understand how to do this.

Browser other questions tagged mysql database versioning replication

You are not signed in. Login or sign up in order to post.