{"id":410869,"date":"2024-10-12T08:00:00","date_gmt":"2024-10-12T08:00:00","guid":{"rendered":"https:\/\/www.weixiaoduo.com\/plugins\/sql-to-cpt\/"},"modified":"2025-03-28T19:17:00","modified_gmt":"2025-03-28T19:17:00","slug":"sql-to-cpt","status":"publish","type":"post","link":"https:\/\/www.weixiaoduo.com\/plugins\/sql-to-cpt\/","title":{"rendered":"SQL To CPT"},"content":{"rendered":"

This plugin helps you migrate legacy SQL database tables<\/strong> to WordPress\u2019 Custom Post Types (CPT)<\/strong>. It provides a user-friendly UI interface<\/strong> that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.<\/p>\n

If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!<\/p>\n

\u2714\ufe0f Features<\/h4>\n

Our plugin comes with everything you need to easily migrate SQL tables to CPTs.<\/p>\n

\u2714\ufe0f Import & Convert to CPT<\/strong> feature.
\n\u2714\ufe0f Quick & Lightening Fast uploads<\/strong>.
\n\u2714\ufe0f Friendly, User Interface (UI)<\/strong>.
\n\u2714\ufe0f Custom Post Type Capabilities<\/strong>.
\n\u2714\ufe0f Error Loggging Capabilities<\/strong>.
\n\u2714\ufe0f Custom Hooks<\/strong> to help you customize plugin behaviour.
\n\u2714\ufe0f Available in mutiple langauges<\/strong> such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages.
\n\u2714\ufe0f Backward compatible<\/strong>, works with most WP versions.<\/p>\n

\u2728 Getting Started<\/h4>\n

Head over to the SQL to CPT<\/strong> options page. Upload an SQL file of your choice by clicking on the Import SQL File<\/strong>. This would analyse your SQL table and show you the table name<\/strong> and table columns<\/strong> you are about to import. Once ready, click on the Convert to CPT<\/strong> button to complete the process.<\/p>\n

On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!<\/p>\n

You can get a taste of how this works, by using the demo<\/a> link.<\/p>\n

\u26a1 Why SQL to CPT ?<\/h4>\n
    \n
  1. Because you need something that works great and fast!<\/li>\n
  2. Because you want to port your data across platforms easily.<\/li>\n
  3. Because you don\u2019t want to spend hours building custom software for this.<\/li>\n
  4. Because you think SQL to CPT<\/strong> is cool.<\/li>\n<\/ol>\n

    NB: At the moment, the SQL to CPT<\/strong> plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.<\/p>\n

    \ud83d\udd0c\ud83c\udfa8 Plug and Play or Customize<\/h4>\n

    The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.<\/p>\n

    Want to add your personal touch? All of our documentation can be found here<\/a>. You can override the plugin\u2019s behaviour with custom logic of your own using hooks<\/a>.<\/p>\n

    Contribute<\/h3>\n

    If you\u2019d like to contribute to the development of this plugin, you can find it on GitHub<\/a>.<\/p>\n

    To build, clone repo and run yarn install && yarn build<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

    Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!<\/p>\n","protected":false},"author":65,"featured_media":410870,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"SQL To CPT - \u8587\u6653\u6735\u63d2\u4ef6\u76ee\u5f55","description":"Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!"},"footnotes":""},"categories":[1],"tags":[5855,3550,730,71,1362],"class_list":["post-410869","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-convert","tag-cpt","tag-import","tag-post","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/410869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/comments?post=410869"}],"version-history":[{"count":0,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/410869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media\/410870"}],"wp:attachment":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media?parent=410869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/categories?post=410869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/tags?post=410869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}