Thread: [INTERFACES] Data Migration

[INTERFACES] Data Migration

From
Robert Hiltibidal
Date:
Howdy,

This sounds simple yet i haven't found a way to do this except thru perl
scripts....

I have two databases, crossover and crbak

crossover is the production database and crbak is the development database.

I have unique tables in crossover i want to migrate over to crbak. Can this
be done thru SQL?

something like

Insert in crbak.function

select * from crossover.function;

I/m not sure of the syntax here....

Thanks,

-Rob


************




Re: [INTERFACES] Data Migration

From
Mark Dalphin
Date:
I would find this kind of extension extremely useful!  Databases proliferate
here at an unbelievable rate; and then, 3 months later, someone needs to "join
across the DBs". To do this across DBMS, as suggested below, sounds difficult,
but then, I'm not writing the code...

Mark

> > On Wed, 1 Dec 1999, Tom Lane wrote:
> > > No; in Postgres, different databases are different universes ... and
> > > there are no wormholes in SQL ;-).
> >
> > Does SQL92 say no wormholes?  Is it a major pain to code this?  I've got
> > no complaints as I can see ways to do it from the application level.
>
> I don't know what SQL92 says and. like you, I have easy ways to do this
> at the app level but for what it's worth, here's a suggested syntax
> for this in case someone want to implement it.
>
> OPEN DATABASE  [AS ] [HOST host] [PORT port] [TYPE ]
>
> And use it as
>
> OPEN DATABASE db1 HOST 'other.what.com';
> SELECT * FROM mytab, db1.othertab yourtab
>     WHERE mytab.f1 = yourtab.f1;
>
> or
>
> SELECT mytab.f1, db1.yourtab.f2, ...
>
> The TYPE attribute allows for opening other databases such as Oracle, etc.
>
--
Mark Dalphin                          email: mdalphin@amgen.com
Mail Stop: 29-2-A                     phone: +1-805-447-4951 (work)
One Amgen Center Drive                       +1-805-375-0680 (home)
Thousand Oaks, CA 91320                 fax: +1-805-499-9955 (work)




************