{"id":7745,"date":"2004-08-02T01:14:58","date_gmt":"2004-08-01T23:14:58","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/2004\/08\/02\/migrating-from-microsoft-access-to-mysql\/"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T22:00:00","slug":"migrating-from-microsoft-access-to-mysql","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2004\/08\/02\/migrating-from-microsoft-access-to-mysql\/","title":{"rendered":"Migrating from Microsoft Access to MySQL"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p>\t<img decoding=\"async\" class=\"alignleft\" src=\"\/wordpress\/wp-content\/20040802-ms_access.jpg|70|63|)%><\/div>\n<div class=\"rightbox\"><%image(20040802-mysql.png\" alt=\"\"><\/p>\n<p>Many people are migrating still migrating from Microsoft Access to MySQL.  I came across a freeware program that can simplify the process.  It can migrated all database structure, data, and meta data (indexes, etc).  Download links and screenshots are <a href=\"http:\/\/www.bullzip.com\/products\/msa2mys\/info.php\">here<\/a>.<\/p>\n<p>If all that stops you now is your ASP code, then you can grab a copy of <a href=\"http:\/\/asp2php.naken.cc\/\">ASP2PHP<\/a> and covert it to PHP easily.  Free software is really great.  Open source software is even better. :)<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>Many people are migrating still migrating from Microsoft Access to MySQL. I came across a freeware program that can simplify the process. It can migrated all database structure, data, and meta data (indexes, etc). Download links and screenshots are here. If all that stops you now is your ASP code, then you can grab a &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2004\/08\/02\/migrating-from-microsoft-access-to-mysql\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Migrating from Microsoft Access to MySQL<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,62],"tags":[],"keyring_services":[],"class_list":["post-7745","post","type-post","status-publish","format-standard","hentry","category-general","category-technology"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":33,"url":"https:\/\/mamchenkov.net\/wordpress\/2002\/03\/28\/migrating-development-server\/","url_meta":{"origin":7745,"position":0},"title":"Migrating development server","author":"Leonid Mamchenkov","date":"March 28, 2002","format":false,"excerpt":"Today I did a test move of our development linux server to another machine. It took me less then two hours to do so, considering about 7 GBytes of data, and difference in hardware (Compaq machine and IBM machine). I have used tar, netcat and Red Hat Linux 7.2 disk.\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25946,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/16\/aws-database-migration-service\/","url_meta":{"origin":7745,"position":1},"title":"AWS Database Migration Service","author":"Leonid Mamchenkov","date":"March 16, 2016","format":false,"excerpt":"AWS Database Migration Service is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post showcasing the functionality. Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB,\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"AWS Database Migration Service","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/03\/dms_connect_endpoints_filled_3-500x409.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":9477,"url":"https:\/\/mamchenkov.net\/wordpress\/2005\/09\/20\/migrating-to-gallery2\/","url_meta":{"origin":7745,"position":2},"title":"Migrating to Gallery2","author":"Leonid Mamchenkov","date":"September 20, 2005","format":false,"excerpt":"I've decided to move all my photo albums to Gallery2. I have already started the migration, so don't be too surprised if you can't access some images or albums. A whole lot of new functionality will be available after the move. Among the few are: Searching for albums and images\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27300,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/02\/08\/migrating-a-php-5-app-to-php-7\/","url_meta":{"origin":7745,"position":3},"title":"Migrating a PHP 5 App to PHP 7","author":"Leonid Mamchenkov","date":"February 8, 2017","format":false,"excerpt":"This year I'll be migrating quite a bit of stuff from PHP 5 to PHP 7. \u00a0We haven't started with the process yet, but with the recent indicators like PHPUnit 6 release, I'm sure the priority of this work will start rising. Obviously, I'm familiar with the new features of\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6,"url":"https:\/\/mamchenkov.net\/wordpress\/2001\/11\/09\/microsoft-ldap\/","url_meta":{"origin":7745,"position":4},"title":"Microsoft LDAP","author":"Leonid Mamchenkov","date":"November 9, 2001","format":false,"excerpt":"LDAP saga continues... Finally I have found something that Microsoft did actually good. I have found out that ldifde.exe -f myfile.ldf will export the whole Active Directory structure into myfile.ldf file in LDIF file format (human readable). That is extremely usefull when migrating I have also found Exchange-HOWTO an interesting\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22182,"url":"https:\/\/mamchenkov.net\/wordpress\/2014\/07\/12\/migrating-twitter-bootstrap-2-3-2-to-3-0\/","url_meta":{"origin":7745,"position":5},"title":"Migrating Twitter Bootstrap 2.3.2 to 3.0","author":"Leonid Mamchenkov","date":"July 12, 2014","format":false,"excerpt":"For those of us who are starting to look into Twitter Bootstrap 3.0\u00a0 for new projects and possible migration of old projects from Twitter Bootstrap 2.3.2 to 3.0, I found a couple of good resources. \u00a0 Firstly, this very brief StackOverflow discussion on what has changed between the versions. \u00a0And\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/7745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=7745"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/7745\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=7745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=7745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=7745"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=7745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}