One of my client’s site want to change it’s pages to posts, then he can categorize the posts, with category and tags, the posts made it easy to manage, especially when you have a lot posts. Today I will show you how to transfer your pages to posts or change your posts to pages in 2 ways.
1. Update your database.
Changing posts from pages is incredibly easy. All you have to do is run this short SQL query through PHPMyAdmin.
UPDATE wp_posts SET post_type = 'page' WHERE post_type = 'post'
As you can see from the above code, all content on WordPress is stored in one table, therefore you are simply changing the type of content from a post to a page. As you would expect, you can change content from pages to post in much the same way.
UPDATE wp_posts SET post_type = 'post' WHERE post_type = 'page'
The main limitation from using the above SQL command is that all pages would be converted into posts but would not have a category attached to them i.e. the post would be uncategorized.
2. Use WordPress Plugins.
Here is a great simple easy plugin which can help you change to posts to pages, or pages to posts, work with latest WordPress version, that’s pTypeConverter.
With the help of pTypeConverter, you can converts post types from one to another easily, that means no matter you want to change post to page or page to post, this plugin can do for you. This free WordPress plugin pTypeConverter allows you to easily convert any post type of a certain post to another in an easy to use interface. The plugin will let you change posts to pages and vice versa at the click of a button. It is WordPress 3.0 ready too so allows you to change posts into pages, attachments, revisions and navigation items. A pTypeConverter role capability prevents unwanted users from converting pages (i.e. only Administrators and Editors have this ability to begin with), which can be adjusted by using a Role Manager plugin. Enjoy.