[Çözüldü] mysql (innodb) export verisinin ms sql 2017 ye import sorunu

Merhabalar,

aşağıda örneğini vereceğim veriler debian üzerinde bulunan mysql sunucudan .sql uzantılı olarak export edildiler ve ben bunları ms sql server 2017 üzerinde oluşturduğum midas_kktc veri tabanına import etmek istiyorum. fakat uyumsuzluktan dolayı olsa gerek query çalışmıyor. sizce burada hangi alanları nasıl düzeltmeliyim?

-- MySQL dump 10.13  Distrib 5.5.60, for debian-linux-gnu (i686)
--
-- Host: 127.0.0.1    Database: midas_kktc
-- ------------------------------------------------------
-- Server version 5.5.62-0+deb8u1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `module_cataloging_field_matches`
--

CREATE TABLE `module_cataloging_field_matches` (
  `service` enum('amazon','google','tokat') COLLATE utf8_turkish_ci NOT NULL DEFAULT 'amazon',
  `field_id` int(11) NOT NULL,
  `field_tag` varchar(255) COLLATE utf8_turkish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

--
-- Dumping data for table `module_cataloging_field_matches`
--

LOCK TABLES `module_cataloging_field_matches` WRITE;
/*!40000 ALTER TABLE `module_cataloging_field_matches` DISABLE KEYS */;
INSERT INTO `module_cataloging_field_matches` VALUES ('amazon',1,'Title'),('tokat',1,'245a'),('google',1,'title'),('amazon',112,'Author'),('tokat',112,'100a'),('google',112,'authors'),('amazon',113,'Publisher'),('tokat',113,'260b'),('google',113,'publisher'),('amazon',114,'PublicationDate'),('tokat',114,'260c'),('google',114,'publishedDate'),('tokat',115,'260a'),('amazon',116,'ISBN'),('tokat',116,'020a'),('google',116,'identifier'),('amazon',117,'Label'),('tokat',117,'090a'),('amazon',118,'Languages'),('tokat',118,'041a'),('tokat',119,'041a'),('google',119,'categories'),('amazon',120,'Edition'),('tokat',120,'250a'),('tokat',121,'300a'),('tokat',122,'500a'),('google',122,'description');
/*!40000 ALTER TABLE `module_cataloging_field_matches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `module_circulations`
--

DROP TABLE IF EXISTS `module_circulations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `module_circulations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `collection_id` int(11) NOT NULL,
  `content_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `surname` varchar(150) COLLATE utf8_turkish_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8_turkish_ci NOT NULL,
  `mail` varchar(240) COLLATE utf8_turkish_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `module_circulations`
--

LOCK TABLES `module_circulations` WRITE;
/*!40000 ALTER TABLE `module_circulations` DISABLE KEYS */;
/*!40000 ALTER TABLE `module_circulations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `module_circulations_detail`
--

DROP TABLE IF EXISTS `module_circulations_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `module_circulations_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `circ_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` int(11) NOT NULL,
  `note` longtext COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `module_circulations_detail`
--

LOCK TABLES `module_circulations_detail` WRITE;
/*!40000 ALTER TABLE `module_circulations_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `module_circulations_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `module_exhibition`
--

 

DROP TABLE IF EXISTS `module_exhibition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `module_exhibition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) COLLATE utf8_turkish_ci NOT NULL,
  `collection_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `visible` int(11) NOT NULL,
  `definition` longtext COLLATE utf8_turkish_ci NOT NULL,
  `timeline` int(11) NOT NULL DEFAULT '0' COMMENT '1-show 0-hidden',
  `type_exhib` int(11) NOT NULL DEFAULT '0' COMMENT '0-virtual 1-physical',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `module_exhibition`
--

LOCK TABLES `module_exhibition` WRITE;
/*!40000 ALTER TABLE `module_exhibition` DISABLE KEYS */;
INSERT INTO `module_exhibition` VALUES (1,'Deneme',2,'2014-01-30','2014-02-05',1,'test sergi',1,1),(2,'15 Kasım Cumhuriyet Bayramı',7,'0000-00-00','0000-00-00',1,'',1,1),(3,'Aydın Denktaş',7,'0000-00-00','0000-00-00',1,'',1,0);
/*!40000 ALTER TABLE `module_exhibition` ENABLE KEYS */;
UNLOCK TABLES;