The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
5answers
219 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
170 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
68 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
132 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
145 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 ...
1
vote
5answers
246 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 ...
9
votes
7answers
630 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
530 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
196 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
466 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
113 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.
15
votes
7answers
4k 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 ...
48
votes
5answers
2k views

How can a group track database schema changes?

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