Small and medium business | Business Central, N...

100% data verification

(1) Share

Report

Posted on by AlbertoAlpha

Good morning,
We are doing a migration from On premise to Saas, well,
We collect the data from the company's SQL, and migrate it to Saas through the data and SQL packages. The client told us, how could they know that the data coming from their SQL was the same as that going to Saas? We did the onpremise, but almost at the end the client decided to switch to Saas.
Well now they tell us that they need not only to confirm the number of data, but also that the data be correct and functional in BC, we have used BC table information for this, but it tells us that a number of SQL data has passed bc, not that the data is functional and 100% verified. It is not enough for them to verify it by the users of the system, they want us to verify that quality 100% before that.
can this be done?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (3)

Report

Hi,

For copying data from on-prem to SaaS you should be using Microsoft process.

This video explains how to use Microsoft replication process - https://youtu.be/6WrbjeFdzwA

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
AlbertoAlpha 9 on at

Like (1)

Report

Thank you very much for your answer, but what I need is to verify the data that comes from the SQL of the Business Central onpremise company, the verification consists of a report that tells us how much data has been migrated, if that data in BC onpremise is correct and fulfill the same functions that they fulfilled in the previous software.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (1)

Report

One way is to manually compare the number of tables with data, and the number of records each table has. The two should be the same on-premise and on SaaS. You can use the Table Information Page in BC to do this. For example, export this table to excel to compare.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, if you are only comparing quantities, not content, I think you only need to compare the values in the Table Information table.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No