MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Replacing MS SQL
Posted by: Sean Nolan
Date: April 15, 2005 04:00PM

There might be lots of reasons. The biggest one is that it is almost certain that the SQL they are sending to SQL Server will not run without modification against MySql. Depending on which version of MySql you use, things which are heavily used in most SQL Server based solutions (like stored procedures and subqueries) may not even be available in MySql in which case you'd have to significantly change the SQL.

Data types can also be tricky - you may need to store data in MySql in types that are not completely compatible with the way the app is written.

In short - you could definitely make it work, BUT, depending on how the app is written - making it work could be anywhere from fairly simple to a huge undertaking.

Sean Nolan

Options: ReplyQuote


Subject
Written By
Posted
April 12, 2005 03:26PM
Re: Replacing MS SQL
April 15, 2005 04:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.