List:General Discussion« Previous MessageNext Message »
From:SGreen Date:September 15 2005 4:10pm
Subject:Re: database link
View as plain text  
Yes, you can use the same process. You will need to modify your existing 
code so that you get  the data from Oracle and write it to MySQL. You will 
be able to reuse most, but not all, of your existing script. Those 
portions that connect to your destination server and  write data into the 
database will need to be modified to use the proper MySQL equivalents.

Also, please remember to CC: all responses to the entire list. If I had 
become unavailable due to the demands of my normal job (all but two or 
three active members of the list do NOT work for MySQL, we all have 
regular, full-time jobs) someone else could have responded in my place. It 
also makes any information you gain or provide useful for others as it 
will be in the public realm.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




Ananda Kumar <anandkl@stripped> 
09/15/2005 11:17 AM
Please respond to
anandkl@stripped


To
"SGreen@stripped" <SGreen@stripped>
cc

Subject
Re: database link






Hi Green,
Right now we are doing the same way. The current reporting db is on 
oracle, so we use a cronjob and the scripts connects to main db  using 
database link and fetches data into the reporting database. So i was 
wondering if i can do the same using mysql and connect to oracle db. 
 
Regards
anandkl
 
 

 
On 9/15/05, SGreen@stripped <SGreen@stripped> wrote: 

No. You will need to use an application external to the server to perform 
the data collection process. This application can be one you write 
yourselves or something you purchase. There are many ways to perform 
things on a schedule: 

a) you application continuously runs and performs certain actions 
according to an internal timer 

b) the operating system uses one of its task scheduling services to launch 
your application according to a schedule you set. 

There are absolutely too many  ways to solve your problem to answer your 
question any more specifically. 

Shawn Green 
Database Administrator
Unimin Corporation - Spruce Pine 


Ananda Kumar < anandkl@stripped> wrote on 09/15/2005 10:56:36 AM:

> Hi Green, 

> Thanks for the answer. 
> We are planing to have reporting database on mysql. This reporting 
> database needs to get data from oracle database on a daily basis. It 
> would drop the table and get the fresh data from oracle database. So
> can this be done using database link. 
>   
> Regards 
> anandkl 
>   
> 
> 
>   
> On 9/15/05, SGreen@stripped <SGreen@stripped> wrote: 
> 
> Ananda Kumar < anandkl@stripped> wrote on 09/15/2005 10:33:16 AM: 
> 
> 
> > Hi, 
> > How can i connect from MYSQL db to an oracle database. Do we need to 
create 
> > any database link or use some ODBC.
> > Please help
> >  regards 
> > anandkl 
> 
> 
> The only way to get one MySQL database server to directly manage 
> data in a table that resides within another server is through the 
> Federated storage engine. Federated is a new feature coming with v5. 
> 0 and is similar to MSSQL's "linked table" feature. Currently it 
> only supports MySQL to MySQL table interactions. 
> 
> When you say "connect from MYSQL db to an oracle database" what 
> exactly are you trying to accomplish? What are you trying to do? 
> What problem are you having that you think the "connection" would 
> solve? Please give us some additional details so we can answer your 
> question more thoroughly. 
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine 


Thread
database linkAnanda Kumar15 Sep
  • Re: database linkSGreen15 Sep
RE: database linkMikhail Berman15 Sep
Re: database linkSGreen15 Sep
  • RE: database linkMark Leith16 Sep
    • Re: database linkAnanda Kumar19 Sep
    • Re: database linkAnanda Kumar19 Sep
      • Re: database linkAnanda Kumar20 Sep
Re: database linkSGreen15 Sep