Use import and export wizard to import records from backup database

Accidently two table records are deleted. So, we planned to restore the records from the backup database. We can export the records in CSV file and import the records by using X++. But, we need the records with same RecId.

In SQL, we have import and export tool to copy the records from source to destination tables. Before import the records, we deleted all records from the source tables to avoid duplicate record creation.

So, we have imported the records from the old database backup within 2 minutes. It is not recommended to insert the records directly in the AX database. But we don’t have any other option to fix this issue ASAP.

Please refer into the below link to understand that how to use import and export tool.

https://www.sqlshack.com/techniques-to-bulk-copy-import-and-export-in-sql-server/