If this is a standard CMS (not something you came up with yourself), I would say that a WXR solution is the way to go. It might take some extra work, but it will be a good learning experience and a nice way to build up your WordPress skills. The WXR route will be an automated solution that’s reliable and repeatable.
You might want to consider doing this as an open source project, soliciting help from the community to get it done. The end result will be a useful tool from which others can utilize, improve, and extend. Open source contributions are always nice to list on the resume, too.
Related Posts:
- Why is my database import losing text widget data?
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- What’s the database relationship between a post and its attachments
- Export WP database for import using WP-CLI on Vagrant Box
- Importing posts from old website to new conflicting post ID’s?
- When importing database, it shows error
- MySQL Syntax Error upon restoring database from backup [closed]
- Import live site to local setup without access to live site
- Error establishing a database connection; After importing DB & Theme
- WordPress database import: Row size too large
- Export / import WordPress database
- Merging two databases without borking it
- Importing CSV into database table not working?
- Import users from old WP site to new one
- Connection refused on locahost after importing database?
- Importing Direct to DB – GUID Question
- Best practice to import user base (subscribers) from one website to another?
- Importer fails to import every post
- WordPress database products structure
- Is it good practice to import/export a blog to test a redesign?
- Featured image from custom to WordPress database
- I broke database after reuploading local version – what exactly happened? Database error
- Importing Concrete5 content to WordPress
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- Using wpdb to connect to a separate database
- How can I make a WordPress database portable and url independent?
- Database connection close
- How to stop WordPress using utf8mb4_unicode_520_ci collation?
- Exporting revisions
- WP_Options ID high
- Default WordPress settings API data sanitization
- How to use multiple database in wordpress?
- Is removing orphaned wp_postmeta records safe?
- Import 10,000 Users into WordPress WITH a specific ID for each user
- Does thumbnail regeneration edit the database?
- Using table lock with wp_insert_post?
- Should I remove transients from the wp_options table?
- WordPress doesn’t show all posts in database
- Adding new row to wp_post table
- Extracting the post_id via the wp_insert_post action (external db query)
- How to interact with another wordpress install on same database?
- Are custom tables in the database overwritten when WordPress is updated to new versions?
- What is the proper way to validate and sanitize JSON response from REST API?
- How to migrate a website based on a custom database to wordpress?
- How do I get the posts within a certain year/date(with sql query)?
- batch UPDATE autoload value in wp_options table
- Displaying BLOB PDF File
- Saving into post_excerpt or post_content
- How to fix the disappearance of the “\” character when updating a post in the database
- Data storage for JS app using WP REST API
- WP CLI Core install – blank database
- Update from 4.5 to 4.6 failing
- Setup 3 Sites To Connect To 1 Database and Share Data
- How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
- Does auto_load to ‘no’ in wp_options improve performance
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
- In which format the data is stored in WordPress Databases?
- Is it possible to rebuild the website while not accesseing the original database?
- Error message on blog posts only on my local environment [closed]
- how to read database fields
- $wpdb->query can’t insert data
- Can you refresh ONLY the wordpress adminbar and not the whole page?
- After database migration, theme mods don’t show [closed]
- Sending posts from Python to WordPress
- Remote database connection and local development
- How can I detect right db type?
- Add search bar to Custom Database Table in WordPress Dashboard
- Design problems when exporting remote database for local development
- Website displays old version of page
- A change in URL slug in database returns 404, how can I do auto-redirect?
- Second ezSQL initialization for MSSQL
- Displaying table data on a page
- muliple wordpress installs (network) on different databases
- White Screen in Home Page
- Continuous SQL query errors from outside source
- Whats the best practise on how to store json data from a custom settings page?
- Recovery – Restore Database after moving folder location locally
- Migrate Users From laravel to wordpress
- WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
- Job and Employee Performance Tracking with Product Safety
- how add more field to wp user and save it to database
- How do I cleanup my database with data that is no longer being used?
- Malware in old website – how to migrate?
- Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
- How to optimize wp_option table?
- How to display $wpdb->insert_id; value on redirected page
- Database for JQuery Autocomplete field
- Should I Use only wpdb Class to Write Custom Queries?
- Catchable fatal error in formatting.php
- Wrong url for the images while using same database for two WordPress installations
- Sending WordPress database information to cross domain the safe way?
- Database Name Change
- Weird characters in title if it contain “ ”
- Where To Find bb_profile_data(); In bbPress?
- How do you build a database-centric site in WP?
- Attach posts based on category and position