Merging of Multiple Databases - How it Works

When combining two or more databases into one for migration purposes, it is important to note what information can be kept and what data will be lost. Some information can be exported and re-imported manually into another TaxCalc database, however this may require some editing from the user’s perspective.

When completing the migration process, TaxCalc will nominate one database to be “kept” as the main source of information. From here, we can complete the transition process to convert the database into another format as required (e.g., to complete the move to network or cloud). Therefore, any data that is outside of that main database (any clients and associated information) will need to be manually exported and re-imported into the upgraded database.

Further guidance on how migrations to another format operate can be found using the links below:

Migrating the Database from Standalone to Network

Migrating the Database from Standalone to CloudConnect

Below is a list of data that can be exported and re-imported into another database:

Please note that we can assist you in exporting the Accounts Production data out of one TaxCalc database (to produce CSV files containing all postings in a trial balance for all accounting periods present) however we do not re-import this data back into the system as standard operating procedure.

Please also note, in the instances whereby there are multiple data sets for one client, a folder will be created for review and manual intervention by the user.

Data that cannot be manually exported and re-imported into another database:

We offer a service where we can complete the following on a database:

We would recommend reading our Knowledge Base article for Merge of Data - What happens next to understand the process that is undertaken and for any actions you are required to take prior to the completion of the paid for service. 

For more information on combining multiple databases, including prices please email sales@taxcalc.com 



Article ID: 2737
Last updated: 15 Mar, 2021
Revision: 20
Technical -> Merging of Multiple Databases - How it Works
https://kb.taxcalc.com/index.php?View=entry&EntryID=2737