Page 1
Page 2
Page 3
Figure 13 – Data entry form
Once we have clicked on the Add button, we will refresh the grid then we can see the new record we have created.
Figure 14 – Data grid after adding a record
At this point, we will do a query on the server, just to show what records are on the server, in the region table.
Figure 15 – Records from region table on SQL Server
This shows the original 4 records we had when we started. If we now click on the Connect & Sync button, we will re-connect to the server, and replicate the database. This time, the new record we have created will be uploaded to the server.
Figure 16 – Synchronisation to upload our new record
If we now switch back to our server, and repeat the query, we will see the new record has been replicated to the server.
Summary
In this article, you should have
- Learned how to access a remote SQL Server
- Access the SQL Server only when you have a connection
- Insert, Delete, Select and Update records
- Configure SQL Server for replication
- Configure IIS for merge replication
- Subscribed to the publication
- Populated a local database
- Added records to a local database, and synchronized it back to the server
Conclusion
I hope this article has served as an introduction to Replication, and shown what is possible with a minimal amount of coding.
Previous Page