i want to migrate the old database data to new database because first i have total 25 custom module and after splitting some of the module will be merged into single and now i have only 12 modules for one project. the previous database size is more than 20 GB and now i want all the previous data into the new database with same database ID. so please help me to find some tools or script which are useful for migration without data losing.
Have you tried taking backup. If you just merged custom modules, it will not change the tables created in database.
Or try export and import
i tried to export and import but not getting success because there is circular relation between two tables. for Ex: when i import the product and not create pos category then it will give error. so it's not possible right now.
Export the data to SQL and import it again (from the terminal) on the target device?