Moving data from one Database to another using date range

(1) Share

Report

Posted on by CU07021022-0

I have an old database that have a lot of issues. I have setup a new database in Bussiness Central 365 . I want to move only data from 1st January 2023 to Data into the new database. How will :

1. Identify the tables that has the Data and

2. How do I do it perfectly

Regards

John Dakurugu

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Dr Gomathi MVP, MCT... 395 Super User 2025 Season 2 on at

Like (0)

Report
Migrating data selectively from an old Business Central (BC) database to a new one based on a date range requires careful planning. Below is a structured approach to identify and transfer the required data efficiently.

Step 1: Identify Relevant Tables

Check key tables like G/L Entry, Sales Invoice, Purchase Ledger, Customer & Vendor Ledger, Item Ledger for date-based records.

Use BC Configuration Packages (SaaS) or SQL Queries (On-Prem) to filter tables containing transactional data from 2023 onward.

Step 2: Move Data to the New Database

For BC SaaS:

Export tables via Configuration Packages in BC.

Filter records in Excel for transactions from Jan 1, 2023, onwards.

Import the cleaned data into the new database.

For BC On-Prem:

Export filtered records from the old DB.

Import data into the new database, ensuring table mappings match.

Step 3: Validate & Test

Compare record counts in both databases.

Verify balances (Customer, Vendor, Inventory) to ensure consistency.

Run test transactions in the new environment before going live.

Regards,

Dr. Gomathi S

Was this reply helpful? Yes No