Sub version for the database (I want something for the data values ​​in the database, not for the schema)

Question

I use github to support versioning and code synchronization. We are a two-person team and we are located in different places.

How can we make sure that our databases are synchronized.

Update: -

I am a rails developer. But these days I am working on drupal projects (where the database is the center of variation). Therefore, I want to make sure that the team must have a synchronized database. Also values ​​in different tables.

I need something that synchronizes our data values.

A centralized database is a good solution. But everything bothers when someone is working offline

Answer 1

Take a look at Red Source SQL Source Control - http://www.red-gate.com/products/SQL_Source_Control/

Honestly, I never used it, but their other software is fantastic. And if all you want to do is keep the database schema in sync (rather than full source control), then I used my SQL Compare product very successfully in the past.

(ps. I do not work for them!)

Answer 2

if you use visual studio, then you can script your database tables, views, stored procedures and functions as .sql files from the database solution, and then check them for version control too - what I am doing on my work place

, script sql .sql [ ], .

Answer 3

Sql Source Control Sql Data Compare : . redgate: .

Answer 4

.

• . , . , , .

• VCS. .

• - . , Doctrine for php yaml, vcs. , 2.

• / script, .

Answer 5

. , SQL Server SVN. . script ( ) . - .

. - , . , , . "" Red Gate, , , .

Answer 6

http://www.red-gate.com/products/SQL_Data_Compare/. . , . , . , , , .

Answer 7

OffScale DataGrove.

- . . , , . , ( , ). , .

- , , . , , - - .

DataGrove.

- OffScale: -)

Answer 8

Wizardby. , .

, , , .