I've been evaluation db solo and it almost fits my needs. I need to
produce ddl file per object. But I also need a "master" file, which
calls all files in the right dependency order.
That's not currently possible. You have two choices a) one file with
all the objects in the dependency order or b) multiple files with no
specified order.
You could maybe generate both, then try to create the master file from
the single file using 'grep' and trying to match the pattern in the
header section for each object.
On Sun, May 10, 2009 at 5:58 PM, <jernej.k...@gmail.com> wrote:
> Hi,
> I've been evaluation db solo and it almost fits my needs. I need to
> produce ddl file per object. But I also need a "master" file, which
> calls all files in the right dependency order.
One file for all the objects is ok (I could extract schema twice -
once for versioning and once for actual scripting), but it seems
dependencies are not handeled right for my schema. For example, a
trigger is generated before the table (and of course trigger creation
fails).
The database is oracle 11g. I have selected to keep the right
dependency order. Am I missing something?
Thanks
On 11 maj, 00:44, DB Solo <mhant...@gmail.com> wrote:
> That's not currently possible. You have two choices a) one file with
> all the objects in the dependency order or b) multiple files with no
> specified order.
> You could maybe generate both, then try to create the master file from
> the single file using 'grep' and trying to match the pattern in the
> header section for each object.
> Marko
> On Sun, May 10, 2009 at 5:58 PM, <jernej.k...@gmail.com> wrote:
> > Hi,
> > I've been evaluation db solo and it almost fits my needs. I need to
> > produce ddl file per object. But I also need a "master" file, which
> > calls all files in the right dependency order.
> One file for all the objects is ok (I could extract schema twice -
> once for versioning and once for actual scripting), but it seems
> dependencies are not handeled right for my schema. For example, a
> trigger is generated before the table (and of course trigger creation
> fails).
> The database is oracle 11g. I have selected to keep the right
> dependency order. Am I missing something?
> Thanks
> On 11 maj, 00:44, DB Solo <mhant...@gmail.com> wrote:
>> That's not currently possible. You have two choices a) one file with
>> all the objects in the dependency order or b) multiple files with no
>> specified order.
>> You could maybe generate both, then try to create the master file
>> from
>> the single file using 'grep' and trying to match the pattern in the
>> header section for each object.
>> Marko
>> On Sun, May 10, 2009 at 5:58 PM, <jernej.k...@gmail.com> wrote:
>>> Hi,
>>> I've been evaluation db solo and it almost fits my needs. I need to
>>> produce ddl file per object. But I also need a "master" file, which
>>> calls all files in the right dependency order.
Actually there was a problem with the dependency sorting, which should
hopefully be fixed now. Please download the latest from
dbsolo.com/preview and let me know how it works.
On Mon, May 11, 2009 at 4:24 AM, <jernej.k...@gmail.com> wrote:
> One file for all the objects is ok (I could extract schema twice -
> once for versioning and once for actual scripting), but it seems
> dependencies are not handeled right for my schema. For example, a
> trigger is generated before the table (and of course trigger creation
> fails).
> The database is oracle 11g. I have selected to keep the right
> dependency order. Am I missing something?
> Thanks
> On 11 maj, 00:44, DB Solo <mhant...@gmail.com> wrote:
>> That's not currently possible. You have two choices a) one file with
>> all the objects in the dependency order or b) multiple files with no
>> specified order.
>> You could maybe generate both, then try to create the master file from
>> the single file using 'grep' and trying to match the pattern in the
>> header section for each object.
>> Marko
>> On Sun, May 10, 2009 at 5:58 PM, <jernej.k...@gmail.com> wrote:
>> > Hi,
>> > I've been evaluation db solo and it almost fits my needs. I need to
>> > produce ddl file per object. But I also need a "master" file, which
>> > calls all files in the right dependency order.
|
