I have five computers connected to the server. They all have MSSQL 2008. There's only one database and it has 5 tables. The largest has about 1 million rows.
When someone logins from one of the computers and starts my application, I want the application to compare the tables in the local database to the tables located in the server database. If changes are detected, I want the local database updated.
I've thought of using the method suggested on the following page but it could be slow on large tables:
What other options do I have?