User of MS SQL

[Satyasai_P]

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

[sashi]

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.. :)

[sashi]

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.. :)