The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
13 views

Schema setup and versioning for multiple DBMS [closed]

I'm working on a project for which we would like to allow users to provide their own database server instead of using our embedded PostgreSQL instance (some have their own infrastructure in place with ...
0
votes
1answer
81 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
2answers
178 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 ...
0
votes
1answer
170 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 ...
0
votes
1answer
295 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 ...
3
votes
6answers
2k 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 ...
-3
votes
2answers
754 views

Versioning data in Databases [closed]

Is there any ready mechanism in Oracle, SQL Server, PostgreSql or OR framework (C#), which can version information in a database? By versioning informartion I mean that e.g. I have table Person (id, ...
1
vote
3answers
291 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
246 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 ...
2
votes
2answers
421 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
525 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 ...
12
votes
8answers
2k 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 ...
10
votes
4answers
930 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 ...
5
votes
1answer
335 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
649 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 ...
6
votes
3answers
2k 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
128 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.
17
votes
8answers
11k 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 ...
55
votes
5answers
4k views

How can a group track database schema changes?

What version control methodologies help teams of people track database schema changes?