Strebel Pierre-Alain (Wirtschaftsinformatiker) wrote:
> good morning
>
> is there anybody experienced in using subversion for oracle database objects (table scripts, migration scripts, stored procedures, etc.)?
>
> how did you build up your repository?
>
>
We took a database dump of an empty shell as the seed, and then just
started saving the scripts into specific folders (e.g.
tables/procedures/views, etc). Our upgrade process from version to
version runs all table, procedure, and view scripts, compiles, then runs
any migration/manipulation scripts. Each of these are stored in version
specific tags in Subversion so we can grab only the database update
scripts for each version based on how far back we need/want to go.
Typically we only go back one major release with this process. For
those clients who need to go back further, we use a diff tool for
databases (there are open source and commercial products that can do
this) to find the diffs from one major version to another and apply
those diffs as what we call a "Mega-Patch". Then we consolidate the
migration/manipulation scripts. This process will usually go back two
major releases.
Our structure looks something like this...
/trunk
/program_files
/database_files
/oracle
/tables
/pkgs
/functions
/procs
/views
/constraints
/otherdatabases...
/tags
/v1.x
/v1.1
/program_files
/database_files
/same_folders_as_above
/v1.1.1(e-patch)
Hope that helps.
Regards,
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Wed Jul 5 14:20:55 2006