Uploads changes from a pulled tracked table in Microsoft SQL Server Compact 3.5 back to the originating table in Microsoft SQL Server. These changes are either individually applied to the server or batched together in a single transaction.
To use the Push method, the application must have created the local SQL Server Compact 3.5 table by calling the Pull method with the* RDA_TRACKOPTION *parameter set to either TRACKINGON or TRACKINGONWITHINDEXES.
Before calling the Push method, the following properties must be set:
The InternetUrl property must contain the URL of the SQL Server Compact 3.5 Server Agent.
The LocalConnectionString property must contain the OLE DB connection string for the SQL Server Compact 3.5 database on the device.
The InternetLogin and InternetPassword properties must be specified if the SQL Server Compact 3.5 Server Agent is configured to use Basic or Integrated Authentication.
object.Push (LocalTableName, OLEDBConnectionString, RDA_BATCHOPTION)
Applies To
SQL Server Compact 3.5 RDA object
LocalTableName
The name of the pulled tracked SQL Server Compact 3.5 table that contains updated records to be sent back to the SQL Server table.OLEDBConnectionString
The OLE DB connection string for the SQL Server database.RDA_BATCHOPTION
The RDA_BATCHOPTION enumeration. Specifies whether the rows being sent back to the SQL Server table should be batched together in a single transaction or applied individually. For more information, see RDA_BATCHOPTION.
If you specify the ErrorTableName parameter when calling the Pull method, any errors that are detected during the push are logged in the error table. For more information about how the error table works, see RDA Conflict Detection and Reporting.