Re: How To Port MS SQL Database to MySQL
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
Re: How To Port MS SQL Database to MySQL
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
Istiaque Hussain 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 > Since there is no stored proceedure support your best option would be to convert your stored procedures into some type of library that would be native to the application you are writting, then use calls to the data library ratther than the stored proceedures in the application. - 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