Questions tagged [version-control]
Version control for database structural and code components.
37
questions
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 ...
- 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 ...
- 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 ...
- 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 ...
- 131
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 ...
- 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 ...
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 ...
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 (...
- 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 ...
- 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 ...
- 6,028
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, ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 175
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?
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 ...
- 121
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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, ...
- 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 ...
- 113
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 ...
- 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 ...
swade1987
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 ...
- 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 ...
987 S
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 ...
- 483
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 ...
- 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 ...
- 1,067
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.
- 965
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 ...
- 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?
- 1,128