Questions tagged [version-control]

Version control for database structural and code components.

Filter by
Sorted by
Tagged with
1 vote
1 answer
37 views

How to deal with fact table data that needs to be version controlled?

I have the following simplified sport_match 'fact' table: match_id tournament_id player_id_p1 player_id_p2 p1_final_score p2_final_score 1 1 1 2 1 0 2 1 1 2 3 1 3 2 3 2 2 3 4 2 3 2 4 0 The table ...
user avatar
  • 131
0 votes
1 answer
18 views

Do I have the right Slowly Changing Dimensions type for my version controlled tennis match database?

I'm trying to version control my database using the principles of Slowly Changing Dimensions. I've opted to use Type 2 with a generation start and end column instead of datetimes. In a simplified ...
user avatar
  • 131
2 votes
1 answer
60 views

Version control for Oracle databases

I'm setting up a version control for several databases. There are some objects like functions/procedures/packages that appear in all the databases, that is, each such object has an identical instance ...
user avatar
  • 21
0 votes
1 answer
359 views

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 ...
user avatar
1 vote
3 answers
1k views

DB2, How to save all stored procedures as files

How does one extract all stored procedures from a DB2 schema as individual files (without using Data Studio so it can be scripted). I need them all so I can uploaded to source control. I have found ...
user avatar
  • 73
0 votes
0 answers
212 views

Liquibase on Oracle SQLcl - table and index drops not being propagated

I've been using Oracle's SQLcl, specifically the lb command to use Liquibase, for the last day or so to use for versioning my development, staging and production databases, which are using Oracle's ...
user avatar
1 vote
0 answers
160 views

Integrating Flyway and Github [closed]

I was wondering if any of you can share some experience regarding integrating Flyway and Git. We're currently developing a project, each sprint we need to make database changes for new features of ...
user avatar
1 vote
1 answer
319 views

postgresql materialized views vs versioning

I came across a pickle when dealing with question from one of our dev concerning postgresql and materialized views: can I refresh materialized view with my application user? well according to docs (...
user avatar
  • 11
0 votes
1 answer
274 views

MySQL MSI appears to be installing wrong (latest) MySQL version

For compatibility reasons with other software, I'm trying to install MySQL 5.6.40 on Windows 10. Any version from 5.7 onward is incompatible with my other programs. I've been trying to use the MSI ...
user avatar
  • 103
1 vote
4 answers
882 views

SQL Server Agent Job - Adding Version Number

I would like to know how to add a version number to a SQL Server Agent job without using the description field, and with it being an attribute of the job. A similar question was asked at ...
user avatar
2 votes
2 answers
6k views

Can I use GIT directly within Oracle

I'm familiar with Git, I use it every day for web projects. But I'm trying to use it with an Oracle DB, mainly to track different procedures and packages. This Oracle DB lives on a different server, ...
user avatar
  • 123
1 vote
0 answers
163 views

Unable to deploy single SSIS package into SSISDB when referencing parameters

I'm attempting to deploy a single package into an Integration Services Catalog using the project deployment model in SQL 2016. This however is giving me some grief, as I've configured environmental ...
user avatar
  • 21
2 votes
1 answer
546 views

Versioning entities in db with draft option, select query

I have postgresql db where i keep data for jee application. User can edit those data without creating new version of entity(draft). During edit, entity is copied as draft(version set to -1) after ...
user avatar
  • 23
4 votes
1 answer
3k views

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 ...
user avatar
  • 4,605
2 votes
1 answer
672 views

How to maintain Database audits?

I am using MySQL database (with Django ORM). I want to maintain the database audits similar to StackOverflow, Quora, Wikipedia, etc. These websites maintain the revisions of the changes in the ...
user avatar
3 votes
2 answers
18k views

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?
user avatar
2 votes
0 answers
793 views

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 ...
user avatar
2 votes
1 answer
495 views

Does READ COMMITTED always start over after serialization failures while SERIALIZABLE simply fails?

On the PostgreSQL Concurrency With MVCC page, it says: know what you’re thinking though: what about a two transactions updating the same row at the same time? This is where transaction isolation ...
user avatar
  • 535
1 vote
0 answers
118 views

How to determine a schema version at runtime [duplicate]

Is there a portable way or best practice to access a version number for a schema at runtime? Rationale: you have multiple systems (development, QA, etc.) where you push schema changes from one system ...
user avatar
  • 111
6 votes
3 answers
2k views

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 ...
user avatar
  • 161
2 votes
3 answers
110 views

Profiling feature for SQL Server 2012

I'm using SQL Server 2012 to develop php/web applications. On my development machine, I have SQL Server also. The php codebase is version controlled with git. The various applications we have (and ...
user avatar
  • 133
2 votes
2 answers
804 views

Storing revisions in SQL Server (simply much like TFS)

So, what I've got so far: Table: ChangeSets Columns: Id | Comment | Committer Table: Customers Columns: Id | Name Table: CustomerChangeSets Columns: Id | CustomerId (FK) | ChangeSetId (FK) So ...
user avatar
  • 249
6 votes
1 answer
5k views

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 ...
user avatar
  • 321
1 vote
2 answers
2k views

Managing version control of Erwin file changes with multiple environments

What is the easiest way to manage three environments (DEV, QA and PROD) within a single Erwin file or multiple Erwin files? The Erwin file is separated by subject area, so I'm not sure reverse ...
user avatar
  • 2,005
19 votes
7 answers
30k views

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 ...
user avatar
  • 789
2 votes
3 answers
3k views

How do you manage SQL jobs that belong to a database?

We just had an issue where we lost msdb on one of our servers along with all of the jobs which we created for a multitude of databases. The fact that we didn't have a backup of msdb is one issue, ...
user avatar
  • 161
1 vote
1 answer
920 views

Best structure for user-level versioning of data in mysql

I have an application I'm building that allows users to upload data files and I read the contents of the data file into a database. All the data files have the same fields, but there may be slight ...
user avatar
8 votes
3 answers
8k views

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 ...
user avatar
  • 221
2 votes
6 answers
2k views

What are the advantages of having a centralised SQL database server for development?

I have an idea to use for my fellow developers and basically wanted feedback. The idea is to have a centralised SQL Server database server for all developers to use. Each developer would have either ...
user avatar
19 votes
9 answers
5k views

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 ...
user avatar
  • 6,552
12 votes
5 answers
3k views

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 ...
user avatar
6 votes
1 answer
2k views

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 ...
user avatar
4 votes
2 answers
1k views

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 ...
user avatar
  • 1,662
9 votes
4 answers
4k views

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 ...
user avatar
1 vote
1 answer
161 views

version controll application/system for mysql databases [duplicate]

Possible Duplicate: Keeping track of schema changes Hello, How do you keep your mysql database schema under version control.
user avatar
32 votes
9 answers
37k views

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 ...
user avatar
  • 23.5k
68 votes
5 answers
12k views

How can a group track database schema changes?

What version control methodologies help teams of people track database schema changes?
user avatar
  • 1,128