Link to home
Start Free TrialLog in
Avatar of noobe1
noobe1

asked on

Check changes and update MSSQL on remote computer

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:
http://stackoverflow.com/questions/36/check-for-changes-to-a-sql-table 

What other options do I have?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Chris M
Chris M
Flag of Uganda image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial