MSSQL Script für MySQL nutzen?

IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = N'TEST')  

BEGIN 
		CREATE DATABASE [TEST]
END

GO

USE TEST

GO

/***********************************************************************************************************************************************************/

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='test_1_tmp')  
DROP Table test_1_tmp

GO

IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='test_1_tmp')  
CREATE TABLE test_1_tmp

	(
	ID VARCHAR(8000)
	)

GO

IF NOT EXISTS (SELECT column_name FROM INFORMATION_SCHEMA.columns WHERE table_name = 'test_1_tmp' AND column_name = 'wert1')  
 
ALTER TABLE test_1_tmp ADD wert1 VARCHAR(8000)

GO

IF NOT EXISTS (SELECT column_name FROM INFORMATION_SCHEMA.columns WHERE table_name = 'test_1_tmp' AND column_name = 'wert2')  
 
ALTER TABLE test_1_tmp ADD wert2 VARCHAR(8000)

GO

/***********************************************************************************************************************************************************/


BULK INSERT test_1_tmp
FROM 'C:\ProgramData\test.txt' WITH  

	(
	FIELDTERMINATOR = ';',  
	ROWTERMINATOR = '\n'  
	)

GO

/***********************************************************************************************************************************************************/

IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='test_1')  
CREATE TABLE test_1

	(
	ID VARCHAR(8000)
	)

GO

IF NOT EXISTS 
	(
	SELECT column_name 
	FROM INFORMATION_SCHEMA.columns 
	WHERE table_name = 'test_1'  
	AND column_name = 'wert1'  
	)
 
ALTER TABLE test_1 ADD wert1 VARCHAR(8000)

GO

IF NOT EXISTS 
	(
	SELECT column_name 
	FROM INFORMATION_SCHEMA.columns 
	WHERE table_name = 'test_1'  
	AND column_name = 'wert2'  
	)
 
ALTER TABLE test_1 ADD wert2 VARCHAR(8000)

GO

/***********************************************************************************************************************************************************/

MERGE test_1 t 

USING test_1_tmp s ON 
	
	(
	s.ID = t.ID
	)
	
WHEN MATCHED THEN UPDATE SET 
    
	t.ID = s.ID,
	t.wert1 = s.wert1,
	t.wert2 = s.wert2
	
WHEN NOT MATCHED BY TARGET THEN INSERT 
	
	(
	ID, wert1, wert2
	)
    
VALUES
	
	(
	s.ID, s.wert1, s.wert2
	);

/***********************************************************************************************************************************************************
	
WHEN NOT MATCHED BY SOURCE THEN DELETE;

************************************************************************************************************************************************************/

GO

/***********************************************************************************************************************************************************/

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='test_1_tmp')  

DROP Table test_1_tmp

GO

/***********************************************************************************************************************************************************/
/***********************************************************************************************************************************************************/
/***********************************************************************************************************************************************************/