Re: How To Port MS SQL Database to MySQL

[Dennis Salguero]

I believe that stored procedures are still on the TODO list, but that might
not fit into your client's plans.

Recall that stored procedures are a form of compiled SQL code. Therefore,
if you want, you could take that SQL code, in the stored procedure, and put
it into your VB application and execute the SQL statement (with a VB
connection object) in place of calling the stored procedure.

While this does negate the advantage of having a stored procedure, it is one
of the few (if not the only) work-arounds for this problem.

Good Luck,

Dennis
**
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com

- Original Message -
From: Istiaque Hussain [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 11:39 AM
Subject: How To Port MS SQL Database to MySQL


 Dear Friends ,

   One of our clients wants to port the Database which was originally in MS
SQL , to MY SQL . he main problem we are facing is that how to make previous
stored procedures run . There are a lot in the application . Front end was
in VB .
   We are now into feasibility study . Please give information on that .

   Bablu



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How To Port MS SQL Database to MySQL

[Rene Tegel]

We encountered no real problems when converting a database from Interbase, with some 
stored procedures and triggers as well, to mysql.

Most stored procedures were for things like generating a unique key, getting the 
server date/time/year, etc.

Triggers are imho just application _unfriendly_, since the programmer has no influence 
on triggers in the database, unless he/her alters them, which can be quite annoying.

Maybe your application(s) need some extra lines of code, but personally i do not see 
this as a limition. Our app was in fact, with some minor issues, fully compatible with 
mysql (it's a compiler switch now :)).

regards,

rene


On Tue, 24 Apr 2001 11:39:55 -0400 (EDT)
Istiaque Hussain [EMAIL PROTECTED] wrote:

 Dear Friends ,
 
   One of our clients wants to port the Database which was originally in MS SQL , to 
MY SQL . he main problem we are facing is that how to make previous stored procedures 
run . There are a lot in the application . Front end was in VB .
   We are now into feasibility study . Please give information on that .
  
   Bablu
 
 __
 Ayna, The Arabic Internet Starts Here. http://www.ayna.com
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php