You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests. The sales team uses portable…

You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests. The sales team uses portable computers to update data frequently in a local database. When the portable computers connect to the central site, the local database must be synchronized with a database named Sales. You plan to create a replication model to replicate the local database to the Sales database. The replication model must meet the following requirements:

• Data conflicts are handled when multiple users update the same data

independently.

• The sales team cannot update sensitive data such as product price.
• The sales team can synchronize data at scheduled times and on demand

also. You need to identify the best model to replicate data by using minimum development efforts. What should you do?