I have a sql server database on my server and another one on my laptop that I use to go out and time races (5ks, nordic ski meets, etc), Given the oftentimes lack of internet connectivity I have to move the data from the server to the laptop, go time the race, and then move it back to the server with the new results. To move the data I simply copy the data files from the data folder to dropbox or a jump drive and then go get them... Is there a better way?
Years ago I tried to use replication with sql server 2000 but, not being a db professional, I just couldn't get it right. My next effort will be to write a script that will identify new data and write that into the db via a web page. Before I do that I am wondering if there is a better approach for a hack like myself.
Look under "replication" to see features supported (Note SQL Sever Change Tracking)
Then lookunder Datawarehouse Scal and Performance (note CDC)