CODEWITHSUNDEEP
mysqldatabase-administration
marklong
marklong

Reputation: 191

Synchronising multiple tables

I have multiple tables which needs to be in-sync with the production database tables. Is there any way to ensure the data is synced with the production database other than manually updating the tables.

Upvotes: 0

Views: 39

Answers (2)

Adarsh
Adarsh

Reputation: 726

Not sure what database you are using, if it is MySQL then replication is the best option to sync.

Upvotes: 1

Vipin Jain
Vipin Jain

Reputation: 3756

You can use the liquibase for this purpose. This is awesome tool for database

Liquibase is an open source database-independent library for tracking, managing and applying database schema changes. It was started in 2006 to allow easier tracking of database changes, especially in an agile software development environment.

Wikipedia Information

Liquibase Main Site

Hopefully this will help you.

Upvotes: 1

Related Questions