Subject Re: copying data between FB DBs on the same machine
Author opher_shachar
--- In, "Alan McDonald" <alan@m...>
> > I have two different DBs on one server machine (ie. 'DB1.fdb'
> > & 'DB2.fdb'), and I need to copy data from a table in one DB to
> > the other DB.
> > Currently I do this from inside my program: I copy data between
> > two recordsets.
> > Question: Can I do this by means of an sql INSERT/SELECT?
> > In MSSQL7 I would use: insert into table1 select * from
> > Quick and painless :-)
> >
> > Thanx for any help
> Is there a reason you don't have just one database?
> Is this required regularly?
> Is this to be done manually each time?
> Bottom line you can't yet do what you want server to server...
there are
> other ways to get the same end point though
> Alan
Hi Alan,
There are two diffrent programs each with it's own DB.
Also, both DBs are on the same machine, so I need to copy DB to DB
(not server to server).
Can I use CONNECT and/or SET DATABASE to accomplish this?