Development | .NET Compact Framework

Using replication on a SQL Server Database
Written by Pete Vickers  [author's bio]  [read 15121 times]
Edited by Derek

      

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 

Back to .NET Compact Framework | [Article Index]