up vote 0 down vote favorite
share [g+] share [fb]

For test/development I need to (repeatedly, e.g. daily) create a portable (partial) copy of an oracle database using SQLite.

By "copy" I mean: table structure and a subset of the data. No indexes, triggers or all the other goodness ..

In order to save on bandwidth and local storage, I'd like to be able to pass table names and data restricting conditions for each table.

Does such a tool exist or am I better off writing my own?

EDIT: I've written my own by now, it's a typical QDH (Quick, Dirty Hack) .. I shudder when I consider who will have to bugfix in the future ..

link|improve this question
50% accept rate
feedback

1 Answer

up vote 1 down vote

Why not having a development Oracle database? Afaik it's free for development use and you could use Oracle's DataPump which is very easy to use and flexible to do just what you want.

There is also a "lite" version of Oracle called Oracle Express so that you don't need to wrestle with Enterprise install...

link|improve this answer
Valid questions ... The (unsatisfactory) answer is: I cannot install Oracle ("Why do you need a DB on that notebook") .. but I may use Perl DB access modules.. (ppm install DBD:SQLite). A really lame, but real world situation.. – lexu May 31 '09 at 6:28
Lame comment: I never grok employers who require digging and forbid spades and picks and where developers don't 0wn own computers. What about virtual machines? :P I'd try to get around as writing a sync is surely interesting but a loss of time. – slovon Jun 1 '09 at 13:37
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.