Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [version-control]

Version control for database structural and code components.

Use this tag for questions involving version control for database structural and code components.

This may include tracking changes made by DDL statements within the database itself.

38 questions
68
votes
5 answers

How can a group track database schema changes?

What version control methodologies help teams of people track database schema changes?
Toby
  • 1,128
  • 2
  • 12
  • 12
33
votes
9 answers

How do you version your Oracle database changes?

I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc. Do you use flat files with an external version control system? …
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
20
votes
9 answers

Version control for database objects

The database our developers are working on is too large (have a lot of database objects). We have to control db objects changes (change management). Our company cannot have a person who would be responsible for db changes only. So we need a source…
garik
  • 6,782
  • 10
  • 44
  • 56
19
votes
7 answers

Stored Procedures under Source Control, best practice

I am currently using Tortoise SVN to source control a .NET Web Application. What would be the best way to bring our SQL Server stored procedures into Source Control? I am currently using VS 2010 as my development environment and connecting to an…
QFDev
  • 789
  • 1
  • 9
  • 21
12
votes
5 answers

What are efficient ways to deal with database schemas that are shared between code branches?

Working on a project with multiple branches, where each branch is eventually merged back to the main branch, and in essence is isolated in order to develop a new feature. The database, which is MS SQL Server, has a shared schema, however each branch…
987 S
9
votes
4 answers

How to version control PostgreSQL schema with comments?

I version control most of my work with Git: code, documentation, system configuration. I am able to do that because all my valuable work is stored as text files. I have also been writing and dealing with lot of SQL schema for our Postgres database.…
Aleksandr Levchuk
  • 1,227
  • 1
  • 10
  • 11
8
votes
3 answers

How do I save functions to individual files in PostgreSQL?

I maintain a legacy application that uses a PostgreSQL database. The application is heavily dependent on stored procedures (aka functions). I want to save these functions to files named after the function name so I can then use a VCS (version…
Fernando
  • 221
  • 1
  • 2
  • 7
7
votes
1 answer

How to handle versions of an Entity in Database Design

I am working on a new project. The domain logic of the project is as follows: A user uploads a file (Document) and gives a title, then another user comes along and (s)he also tries to upload a file with the same title. This is OK providing that the…
J86
  • 331
  • 6
  • 14
6
votes
3 answers

Building a branched versioning model for relational databases

I am database designer and at my current project I'm implementing versioning capabilities required to concurrently edit rows of data in RDBMS. The project requirements says, that data editing sessions can go on for several hours or days until…
Nipheris
  • 161
  • 1
  • 4
6
votes
1 answer

How can I design a table for quick versioning of textual data?

Version i am talking about here is not of version control systems. Like in SO i got some textual data(compare them to questions) that could be versioned(in the sense edited, saved, rollback). Content of Each edit, update, save is to be saved as new…
Deeptechtons
  • 493
  • 2
  • 5
  • 19
4
votes
2 answers

Difference between storing a DBUnit file in version control and using Liquibase for Database Version control?

What is the difference between storing a DBUnit database-loadable xml file in version control, and using Liquibase for database version control? I'm relatively familiar with DBUnit having used it in Matt Raible's Appfuse project, and I've used it…
leeand00
  • 1,722
  • 6
  • 20
  • 36
4
votes
1 answer

Howto create useful dacpac versioning along with SSDT deployment?

It took me almost one day to go through lots of articles and blogs to realize check-in driven continuous integration with SQL Server Database Projects (SSDT) using TFS and msbuild. Now once this is working properly, I would like to introduce…
Magier
  • 4,827
  • 8
  • 48
  • 91
3
votes
2 answers

How can I know my database version?

I need to know what is my database version. I'm using DB2 V9.7 on linux 64 bits. I'm connected to a database and i need to know if it is 32 or 64 bits. Can someone help me?
Helmuth Fernandes
  • 65
  • 1
  • 2
  • 7
3
votes
1 answer

pg_dump - how to split it into directories and files?

I am looking for a way to dump PostgreSQL12 database model into a directory/file structure, instead of a single file - for versioning purposes. I found this old thread, which mentions this exact case and describes a --split flag to be used with…
Leon Powałka
  • 161
  • 1
  • 4
2
votes
0 answers

Are there any databases with out of the box Point-in-Time-Architecture support?

I am looking for the descriptive term of a database system (available in the cloud, or to be deployed on a local server) that has build-in support for a point-in-time (PTA) architecture. I am not sure that PTA is the common term for these kind of…
Rabarberski
  • 121
  • 2
1
2 3