{"id":38,"date":"2006-11-12T18:51:17","date_gmt":"2006-11-12T23:51:17","guid":{"rendered":"http:\/\/otac.isa-geek.net\/blog\/?p=38"},"modified":"2006-11-12T18:51:17","modified_gmt":"2006-11-12T23:51:17","slug":"smooth-database-migration","status":"publish","type":"post","link":"https:\/\/otac.isa-geek.net\/blog\/?p=38","title":{"rendered":"Smooth database migration."},"content":{"rendered":"

As the title suggests, my current painpoint on the SOHO front, is the restructuring of the database usage for the various applications and systems I have up. The main ones that offend me are my education forum<\/a> (PHPBB2 <\/a>with MS-Access, yuck!), and my genealogy site<\/a> (PHP flat-file, hurl!!). However, a nice happenstance from the installation of my new blog software, WordPress<\/a> (which is working great, as you can see), is that I was required to get a MySQL<\/a> instance up and running. Since the packages listed above all can use MySQL as their database, it would seem a shame not to take this chance to migrate and consolidate all of my data needs on one platform and product. Also, I really would like to cut my last dependence on the Microsoft toolset – I can be fairly sure that once I am using MySQL as my database source, I can move the data tier of all my systems to a Linux box without any major issues. So, the next step is to come up with detailed database migration plans for both systems – I think this will be an interesting effort, since my previous DBA experience has all been on Oracle. Speaking of Oracle, I have finally had a chance to get back to my work on installing, evaluating, and experimenting with Oracle eBusiness Suite on Linux<\/a> (11i\/10G). My plan is centered on using Ubuntu<\/a> as the OS, with LAMP and the appropriate Oracle stack running on top. So far, I’m still stuck at getting Ubuntu installed on my “server” (converted PC). I’ll post my experiences with getting this set up in the articles<\/a> section of the site.<\/p>\n","protected":false},"excerpt":{"rendered":"

As the title suggests, my current painpoint on the SOHO front, is the restructuring of the database usage for the various applications and systems I have up. The main ones that offend me are my education forum (PHPBB2 with MS-Access, yuck!), and my genealogy site (PHP flat-file, hurl!!). However, a nice happenstance from the installation […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,7,2],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-linux","category-oracle","category-otac"],"_links":{"self":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":0,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"wp:attachment":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}