469,628 Members | 1,084 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,628 developers. It's quick & easy.

User of MS SQL

Hi,

Will the SP's & Triggers writtien in MS SQL work in MySQL ? Or we have to alter. Can some body suggests me if any body has done and how difficult it will be?

satya
Jul 12 '06 #1
2 1476
sashi
1,754 Expert 1GB
Hi Satya,

certain sp's triggers might not work in MYSQL.. reason why, is coz some datatypes used in MYSQL is not same in MSSQL.. i.e. date.. i have done some database migration from MSSQL to MYSQL.. believe me.. it's not easy but can be done.. good luck my fren.. :)
Jul 12 '06 #2
sashi
1,754 Expert 1GB
Hi Satya,

certain sp's triggers might not work in MYSQL.. reason why, is coz some datatypes used in MYSQL is not same in MSSQL.. i.e. date.. i have done some database migration from MSSQL to MYSQL.. believe me.. it's not easy but can be done..

you have consider the version of MYSQL as well.. things turn out to be alot easier when it comes to MYSQL Ver 5.0.. good luck my fren.. :)
Jul 12 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

60 posts views Thread by Fotios | last post: by
3 posts views Thread by zlst | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.