{"id":270,"date":"2009-06-06T23:35:21","date_gmt":"2009-06-07T06:35:21","guid":{"rendered":"http:\/\/techclub.mypctechs.com\/?p=270"},"modified":"2010-08-13T10:44:44","modified_gmt":"2010-08-13T17:44:44","slug":"migrating-from-microsoft-sql-server-and-access-to-mysql","status":"publish","type":"post","link":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/","title":{"rendered":"Migrating from Microsoft SQL Server and Access to MySQL"},"content":{"rendered":"<p>One of the more common themes present on the various MySQL forums and mailing lists is that of data migration. Typically requests are made by users of Microsoft\u00ae Access and Microsoft SQL Server who are looking to migrate their data (and client applications) to a MySQL database. Developers often ask for tools that can be used to convert an Access database to MySQL (or convert an MSSQL database to MySQL), without realizing that there is more to migrating an application to MySQL than simply converting data. <a href=\"http:\/\/dev.mysql.com\/tech-resources\/articles\/migrating-from-microsoft.html\">Read more&#8230;<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a style=\"font-size: larger;\" href=\"http:\/\/ping.fm\/ref\/?link=http:\/\/techclub.mypctechs.com\/?p=270&amp;title=Migrating from Microsoft SQL Server and Access to MySQL&amp;body=Migrating from Microsoft SQL Server and Access to MySQL\">  >> Did you like this article? Ping it!<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the more common themes present on the various MySQL forums and mailing lists is that of data migration. Typically requests are made by users of Microsoft\u00ae Access and Microsoft SQL Server who are looking to migrate their data (and client applications) to a MySQL database. Developers often ask for tools that can be [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-tcg"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"andremorris\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Club | Small Business Technology News and Innovations\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-06-07T06:35:21+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2010-08-13T17:44:44+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#article\",\"name\":\"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club\",\"headline\":\"Migrating from Microsoft SQL Server and Access to MySQL\",\"author\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/author\\\/andremorris\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/#organization\"},\"datePublished\":\"2009-06-06T23:35:21-07:00\",\"dateModified\":\"2010-08-13T10:44:44-07:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#webpage\"},\"articleSection\":\"Tech Club General\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/category\\\/tcg\\\/#listItem\",\"name\":\"Tech Club General\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/category\\\/tcg\\\/#listItem\",\"position\":2,\"name\":\"Tech Club General\",\"item\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/category\\\/tcg\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#listItem\",\"name\":\"Migrating from Microsoft SQL Server and Access to MySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#listItem\",\"position\":3,\"name\":\"Migrating from Microsoft SQL Server and Access to MySQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/category\\\/tcg\\\/#listItem\",\"name\":\"Tech Club General\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/#organization\",\"name\":\"Tech Club\",\"description\":\"Small Business Technology News and Innovations\",\"url\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/author\\\/andremorris\\\/#author\",\"url\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/author\\\/andremorris\\\/\",\"name\":\"andremorris\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#webpage\",\"url\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/\",\"name\":\"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/migrating-from-microsoft-sql-server-and-access-to-mysql\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/author\\\/andremorris\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/author\\\/andremorris\\\/#author\"},\"datePublished\":\"2009-06-06T23:35:21-07:00\",\"dateModified\":\"2010-08-13T10:44:44-07:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/#website\",\"url\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/\",\"name\":\"Tech Club\",\"description\":\"Small Business Technology News and Innovations\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mypctechs.com\\\/techclub\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club","description":"","canonical_url":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#article","name":"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club","headline":"Migrating from Microsoft SQL Server and Access to MySQL","author":{"@id":"https:\/\/www.mypctechs.com\/techclub\/author\/andremorris\/#author"},"publisher":{"@id":"https:\/\/www.mypctechs.com\/techclub\/#organization"},"datePublished":"2009-06-06T23:35:21-07:00","dateModified":"2010-08-13T10:44:44-07:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#webpage"},"isPartOf":{"@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#webpage"},"articleSection":"Tech Club General"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub#listItem","position":1,"name":"Home","item":"https:\/\/www.mypctechs.com\/techclub","nextItem":{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/#listItem","name":"Tech Club General"}},{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/#listItem","position":2,"name":"Tech Club General","item":"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#listItem","name":"Migrating from Microsoft SQL Server and Access to MySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#listItem","position":3,"name":"Migrating from Microsoft SQL Server and Access to MySQL","previousItem":{"@type":"ListItem","@id":"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/#listItem","name":"Tech Club General"}}]},{"@type":"Organization","@id":"https:\/\/www.mypctechs.com\/techclub\/#organization","name":"Tech Club","description":"Small Business Technology News and Innovations","url":"https:\/\/www.mypctechs.com\/techclub\/"},{"@type":"Person","@id":"https:\/\/www.mypctechs.com\/techclub\/author\/andremorris\/#author","url":"https:\/\/www.mypctechs.com\/techclub\/author\/andremorris\/","name":"andremorris"},{"@type":"WebPage","@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#webpage","url":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/","name":"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.mypctechs.com\/techclub\/#website"},"breadcrumb":{"@id":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/#breadcrumblist"},"author":{"@id":"https:\/\/www.mypctechs.com\/techclub\/author\/andremorris\/#author"},"creator":{"@id":"https:\/\/www.mypctechs.com\/techclub\/author\/andremorris\/#author"},"datePublished":"2009-06-06T23:35:21-07:00","dateModified":"2010-08-13T10:44:44-07:00"},{"@type":"WebSite","@id":"https:\/\/www.mypctechs.com\/techclub\/#website","url":"https:\/\/www.mypctechs.com\/techclub\/","name":"Tech Club","description":"Small Business Technology News and Innovations","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.mypctechs.com\/techclub\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Club | Small Business Technology News and Innovations","og:type":"article","og:title":"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club","og:url":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/","article:published_time":"2009-06-07T06:35:21+00:00","article:modified_time":"2010-08-13T17:44:44+00:00","twitter:card":"summary","twitter:title":"Migrating from Microsoft SQL Server and Access to MySQL | Tech Club"},"aioseo_meta_data":{"post_id":"270","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-20 22:10:03","updated":"2025-06-04 04:35:40","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.mypctechs.com\/techclub\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/\" title=\"Tech Club General\">Tech Club General<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMigrating from Microsoft SQL Server and Access to MySQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.mypctechs.com\/techclub"},{"label":"Tech Club General","link":"https:\/\/www.mypctechs.com\/techclub\/category\/tcg\/"},{"label":"Migrating from Microsoft SQL Server and Access to MySQL","link":"https:\/\/www.mypctechs.com\/techclub\/migrating-from-microsoft-sql-server-and-access-to-mysql\/"}],"_links":{"self":[{"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":4,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":745,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/posts\/270\/revisions\/745"}],"wp:attachment":[{"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mypctechs.com\/techclub\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}