Intelligent backup should be just that... Use GBAK and a scheduler or some
other backup scheduler - look at IBPhoenix for a few. I wouldn't do it the
way you propose.
Alan

> -----Original Message-----
> From: column@... [mailto:column@...]
> Sent: Tuesday, 12 November 2002 22:36
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] select from one_database.table into
> another_database.table
>
>
> This is end of day routine in my app. Something like intelligent backup.
>
> ----- Original Message -----
> From: "Alan McDonald" <alan@...>
> To: <ib-support@yahoogroups.com>
> Sent: Tuesday, November 12, 2002 12:27 PM
> Subject: RE: [ib-support] select from one_database.table into
> another_database.table
>
>
> > is this for a one-off data pump or to do it all the time?
> > Alan
> >
> > > -----Original Message-----
> > > From: column@... [mailto:column@...]
> > > Sent: Tuesday, 12 November 2002 22:07
> > > To: ib-support@yahoogroups.com
> > > Subject: Re: [ib-support] select from one_database.table into
> > > another_database.table
> > >
> > >
> > > So, what I should put in IBSQL1.Database property then? First database
> ore
> > > second?
> > >
> > > ----- Original Message -----
> > > From: "Alan McDonald" <alan@...>
> > > To: <ib-support@yahoogroups.com>
> > > Sent: Tuesday, November 12, 2002 12:00 PM
> > > Subject: RE: [ib-support] select from one_database.table into
> > > another_database.table
> > >
> > >
> > > > no, just put that SQL i mentioned into an IBSQL component
> and execute
> it
> > > > Alan
> > > >
> > > > > -----Original Message-----
> > > > > From: column@... [mailto:column@...]
> > > > > Sent: Tuesday, 12 November 2002 21:51
> > > > > To: ib-support@yahoogroups.com
> > > > > Subject: Re: [ib-support] select from one_database.table into
> > > > > another_database.table
> > > > >
> > > > >
> > > > > Thank you for support.
> > > > >
> > > > > Regarding IBSQL. What is the way of using it?
> > > > >
> > > > > Should I :
> > > > > connect to first_database
> > > > > do select from first_database
> > > > > connect to second_database
> > > > > do insert to second_database?
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Alan McDonald" <alan@...>
> > > > > To: <ib-support@yahoogroups.com>
> > > > > Sent: Tuesday, November 12, 2002 10:00 AM
> > > > > Subject: RE: [ib-support] select from one_database.table into
> > > > > another_database.table
> > > > >
> > > > >
> > > > > > Sorry - I didn't note the reference to SP... You'll be able
> > > to use the
> > > > > IBSQL
> > > > > > component
> > > > > > Alan
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: column@... [mailto:column@...]
> > > > > > > Sent: Tuesday, 12 November 2002 19:45
> > > > > > > To: ib-support@yahoogroups.com
> > > > > > > Subject: [ib-support] select from one_database.table into
> > > > > > > another_database.table
> > > > > > >
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > I need to do this action:
> > > > > > >
> > > > > > > Select from one_database.table into another_database.table
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Is it possible to do this with stored procedure?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > If no then is it possible to do wit IBX components?
> If yes then
> > > > > > > what is the
> > > > > > > best way to do that?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > To unsubscribe from this group, send an email to:
> > > > > > > ib-support-unsubscribe@egroups.com
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Your use of Yahoo! Groups is subject to
> > > > > http://docs.yahoo.com/info/terms/
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > To unsubscribe from this group, send an email to:
> > > > > > ib-support-unsubscribe@egroups.com
> > > > > >
> > > > > >
> > > > > >
> > > > > > Your use of Yahoo! Groups is subject to
> > > > > http://docs.yahoo.com/info/terms/
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > To unsubscribe from this group, send an email to:
> > > > > ib-support-unsubscribe@egroups.com
> > > > >
> > > > >
> > > > >
> > > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > ib-support-unsubscribe@egroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>