{"id":434,"date":"2009-01-26T09:35:49","date_gmt":"2009-01-26T08:35:49","guid":{"rendered":"http:\/\/www.dotmana.com\/index.php\/?p=434"},"modified":"2009-01-26T09:35:49","modified_gmt":"2009-01-26T08:35:49","slug":"how-to-migrate-convert-mssql-bak-into-mysql-sql","status":"publish","type":"post","link":"https:\/\/www.dotmana.com\/weblog\/2009\/01\/how-to-migrate-convert-mssql-bak-into-mysql-sql\/","title":{"rendered":"How to migrate \/ convert MSSQL .bak into Mysql \/ SQL"},"content":{"rendered":"

Here are the steps to follow in order to convert a MsSql (sql server) .BAK into mysql format:<\/p>\n

    \n
  1. you need windows<\/li>\n
  2. download and install Microsoft SQL Server Express<\/li>\n
  3. download and install Microsoft SQL Server Management Studio Express<\/li>\n
  4. download and install Mysql Migration Toolkit (included in Mysql Gui Tools only in Windows package, no linux version \ud83d\ude41 )<\/li>\n
  5. configure your MSSql server to listen on TCP connexion<\/li>\n
  6. load your .bak in SQL Serveur management studio (right clic on database, restose database, from the unit, go to options tab<\/strong> and set a right path for the files listed in the .bak file, launch the recovery)<\/li>\n
  7. in Mysql Migration toolkit, follow the wizard, it should be easy<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Here are the steps to follow in order to convert a MsSql (sql server) .BAK into mysql format: you need windows download and install Microsoft SQL Server Express download and install Microsoft SQL Server Management Studio Express download and install … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-434","post","type-post","status-publish","format-standard","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/comments?post=434"}],"version-history":[{"count":0,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts\/434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/media?parent=434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/categories?post=434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/tags?post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}