You need to ensure that when you delete a customer record, the corresponding order records are deleted…
You need to ensure that the application can detect all conflicts that occur between the offline customer information submitted to the SQL Server and the server version