Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / 100% data verification
Business Central forum
Suggested answer

100% data verification

(1) ShareShare
ReportReport
Posted on by AlbertoAlpha 9
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:
Data Migrations
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,202 Super User 2024 Season 2 on at
    100% data verification
    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
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,078 Super User 2024 Season 2 on at
    100% data verification
    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. 
     
  • AlbertoAlpha Profile Picture
    AlbertoAlpha 9 on at
    100% data verification
    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.
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,959 Super User 2024 Season 2 on at
    100% data verification
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,451 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,353 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans