Convertion from MS Sql to MySql

[manoj_integral]

Hi All,

Below I have given a stored procedure for User Registration in MS Sql

/******Stored Procedure MS Sql Starts Here*******/

CREATE PROC InsertRegDetails
(
@UserId numeric(9) ,
@FName varchar(50),
@LName varchar(50),
@Email varchar(100),
@DepartmentName varchar(50)
)
AS
BEGIN TRANSACTION

INSERT INTO LoginTable VALUES(@UserId,@FName,@LName,@Email)

INSERT INTO DeptTable
VALUES(@UserId,@DepartmentName)

IF @@ERROR<>0
BEGIN
ROLLBACK
RAISERROR('ERROR IN REGISTRATION',16,1)
RETURN
END
COMMIT
GO

/******Stored Procedure for MS Sql Ends Here*******/

I need it to convert into MySql. How I Can do it , Please Help me.


Thanks in Advance
Manoj

[dararamu]

Down load Free Trial version of MsSql <-> MySql from following link
http://www.sharewareconnection.com/m...-converter.htm



or
http://www.snapfiles.com/get/mssqlmysql.html

[Michael Raven]

you can use any 'pump' software like
http://www.sqlmanager.net/en/products/mysql/datapump