Patent ID: 8527460

Claim:
A method for carrying out version-control of a database in a development environment including a master server storing a database to be developed, the database on the master server constituting a master database; one or more local servers storing a local copy of the database; a local machine, upon which database development can be performed; and a metadatabase, which can be accessed by at least the local machine; the method comprising: obtaining the local copy of the database from the master server; providing a duplicate copy of the local copy in the local server, the duplicate copy constituting a reference copy of the database; changing a state of the local copy of the database as part of the development process; deriving a script based on the state change; executing the script on the master database, thereby changing the state of the master database to reflect the state change in the local copy of the database; storing the script on the metadatabase; and storing a reverse script on the metadatabase in addition to the script, wherein reverse script can be executed on at least one of the master server and the local server to change the state of the respective master copy and local copy of the database to an earlier state, wherein the master server is marked to show that the master copy of the database has been changed in accordance with the script, the local server is marked to show that the local copy of the database has been changed in accordance with the script, the script is executed on the reference copy of the database, an ID is allocated to the script when the script is stored on the metadatabase, the ID identifying the script, and the marking is achieved by storing the script ID in a table in the master database and in a table in the local and reference copies of the database.