Home » SQL & PL/SQL » SQL & PL/SQL » Version Control for resources (tables, views, seqs,etc..) ?
Version Control for resources (tables, views, seqs,etc..) ? [message #203868] Thu, 16 November 2006 13:45 Go to next message
sysadmin
Messages: 2
Registered: November 2006
Location: MN
Junior Member
**not sure which forum area to post this in so will just post here **
All the version control products I have come across just provide version control for the code. Is there anything out there that will help with version control for db data resources like tables, views, etc... ??

[Updated on: Thu, 16 November 2006 13:46]

Report message to a moderator

Re: Version Control for resources (tables, views, seqs,etc..) ? [message #203964 is a reply to message #203868] Fri, 17 November 2006 02:10 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Views are just SQL scripts, so they can go in the version control along with everything else.

Static data can go in version control if you're careful. You need to write a set of scripts that will recreate the data without changing any of the primary key values (I use MERGE).
Re: Version Control for resources (tables, views, seqs,etc..) ? [message #203966 is a reply to message #203964] Fri, 17 November 2006 02:15 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
JRowbottom is right.
If you use a version control system that automatically increases a placeholder containing the version number, you can use a table-comment for that.
Previous Topic: ODE for .NET download
Next Topic: PLS-00363 problem..
Goto Forum:
  


Current Time: Fri Dec 09 15:46:56 CST 2016

Total time taken to generate the page: 0.11373 seconds