Questions tagged [version-control]
Version control for database structural and code components.
34
questions
0
votes
3answers
69 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 ...
0
votes
0answers
11 views
Upgrade DAC wizard rebuilds schemabound views for no apparent reason
We recently did a deployment that included upgrading a database via DACPAC.
We extracted the script from the SSMS Upgrade DAC wizard, removed the objectionable parts (dropping users, extended ...
0
votes
0answers
71 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
0answers
84 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
1answer
226 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 (...
0
votes
1answer
228 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 ...
1
vote
4answers
686 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 ...
2
votes
2answers
5k 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, ...
1
vote
0answers
152 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 ...
2
votes
1answer
430 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 ...
4
votes
1answer
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 ...
2
votes
1answer
588 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 ...
3
votes
2answers
16k 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
0answers
752 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 ...
2
votes
1answer
399 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 ...
1
vote
0answers
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 ...
5
votes
3answers
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 ...
2
votes
3answers
107 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 ...
2
votes
2answers
768 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 ...
4
votes
1answer
4k 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 ...
1
vote
2answers
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 ...
17
votes
7answers
27k 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 ...
2
votes
3answers
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, ...
1
vote
1answer
841 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 ...
6
votes
3answers
5k 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 ...
2
votes
6answers
1k 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 ...
19
votes
9answers
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 ...
12
votes
5answers
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 ...
6
votes
1answer
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 ...
4
votes
2answers
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 ...
9
votes
4answers
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
vote
1answer
157 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.
32
votes
9answers
35k 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 ...
68
votes
5answers
11k views
How can a group track database schema changes?
What version control methodologies help teams of people track database schema changes?
