List:General Discussion« Previous MessageNext Message »
From:Stuart Felenstein Date:September 28 2004 5:02pm
Subject:RE: Data fields from one database to another
View as plain text  
Been trying it out.   Seems to be very powerful! 

Thank you ,
Stuart
--- Tim Hayes <tim.hayes@stripped> wrote:

> Yes. Absolutely. MYdbPAL has a complete
> schema-to-schema table and data
> field mapping capability that will also let you do
> things like table splits
> and joins. It also has inbuilt scripting and data
> value translation lookups.
> 
> Timk
> 
> -----Original Message-----
> From: Stuart Felenstein [mailto:stuart4m@stripped]
> Sent: 28 September 2004 09:57
> To: tim.hayes@stripped; mysql@stripped
> Subject: RE: Data fields from one database to
> another
> 
> 
> So it will let me transfar individual fields ? Most
> of
> the clients allow for data transfer provided the
> database schema is the same, and then it is the
> entire
> record.
> 
> Stuart
> --- Tim Hayes <tim.hayes@stripped> wrote:
> 
> > Try using MYdbPAL - its a new free program that
> will
> > do the job plus lots of
> > other goodies.
> >
> > www.it-map.com
> >
> > Tim Hayes
> >
> > -----Original Message-----
> > From: Stuart Felenstein
> [mailto:stuart4m@stripped]
> > Sent: 28 September 2004 08:23
> > To: mysql@stripped
> > Subject: Data fields from one database to another
> >
> >
> > I want to move over 2 - 4 fields from a table in
> one
> > database , to a table in another.  The field names
> > are
> > not an exact match but they function identically
> > (i.e.
> > username, password)
> >
> > Whatever I'm using , web development garbage
> program
> > ;) won't allow me to connect to 2 different
> > databases
> > so I can't do an update or insertion through that
> > means.
> >
> > Wondering how I script something like that, and
> > probably prefer a way to do it on the fly with
> each
> > new sign up , or batched on a regular basis aka,
> > every
> > hour , every few hours.
> >
> > Thank you,
> > Stuart
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> >
>
http://lists.mysql.com/mysql?unsub=1
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> >
>
http://lists.mysql.com/mysql?unsub=1
> >
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=1
> 
> 

Thread
Data fields from one database to anotherStuart Felenstein28 Sep
  • RE: Data fields from one database to anotherTim Hayes28 Sep
    • RE: Data fields from one database to anotherStuart Felenstein28 Sep
      • RE: Data fields from one database to anotherTim Hayes28 Sep
        • RE: Data fields from one database to anotherStuart Felenstein28 Sep