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