Create dumpfile from Oracle DB

[Phil Pinkerton <pc...@gmail.com>]

Has anyone attempted to create a svn dumpfile using sql commands to use for
moving the database data into a SVN repository ?

Re: Create dumpfile from Oracle DB

[Daniel Rall <dl...@collab.net>]

It's theoretically possible (I don't think you're nuts).  :-)

Where you don't have a one-one mapping between what's in your RDBMS
and what you need for the dump file, you of course may have to fill in
some gaps with dummied up data.

On Wed, 15 Aug 2007, Phil Pinkerton wrote:

> I was thinking about the possibility of creating a flat file from the
> database then extracting the data into the svndump format using awk/sed or
> perhaps perl. Am I nuts ? its a bit over my head but I want to do it if it
> is possible.
> 
> On 8/15/07, Daniel Rall <dl...@collab.net> wrote:
> >
> > On Tue, 14 Aug 2007, Phil Pinkerton wrote:
> >
> > > Has anyone attempted to create a svn dumpfile using sql commands to use
> > for
> > > moving the database data into a SVN repository ?
> >
> > You'd have to create a mapping between your RDBMS schema and
> > Subversion's dump file format.  Such a mapping would be specific to
> > each RDBMS schema.
> >
> > I haven't seen anyone attempt this.

Re: Create dumpfile from Oracle DB

[Daniel Rall <dl...@collab.net>]

On Tue, 14 Aug 2007, Phil Pinkerton wrote:

> Has anyone attempted to create a svn dumpfile using sql commands to use for
> moving the database data into a SVN repository ?

You'd have to create a mapping between your RDBMS schema and
Subversion's dump file format.  Such a mapping would be specific to
each RDBMS schema.

I haven't seen anyone attempt this.