View Single Post

   
  #3 (permalink)  
Old 04-03-2008, 02:50 PM
Jerry Stuckle
 
Posts: n/a
Default Re: How to connect My-Sql to Sybase 12.5 (ASE) and Does it supportSP and Job Scheduling

Sanjeev wrote:
> Dear Gurus,
>
> I have following with me.
> 1> My-Sql (version 5.0.24)
> 2> Sybase 12.5 (ASE)
> 3> Windows platform
> 4> Exp. in Oracle 9i (Sql, pl-sql)
>
> I want to do connectivity(Heterogenious) between My-SQL and Sybase.
> I have done similar thing with Oracle 9i and MS-SQL Server 2000
> (Heterogenious Connectivity).
>
> I need to know how much data (in GigaByte/Terabyte) mysql(version
> 5.0.24) can handle?


Multiple TB's. File size may be more of a problem, depending on your
architecture.

> Does mysql(version 5.0.24) support Stored Procedure/function/trigger
> etc. ?


Yes.

> Is there any job scheduling facility in mysql(version 5.0.24)? (Like
> job sheduler in oracle)
> i.e. job will run/execute Stored procedure in periodic manner.
>


No, but the OS has cron, which is much more efficient than Oracle's job
scheduler.

> Could anyone help me in above.
>
> Thanking in advance
> Sanjeev
>
>
>
> .
>
>



--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Reply With Quote