Duplicate Sql Server DB
Posted on 2016-08-03
We time races and, at present, we place a copy of the race db in dropbox the morning of the race and then each crew manually pulls it down and times their race. The changes made locally are uploaded to the server via our software. What i want to know is:
1) Is there a better way to pull all the data down from the db, either completely or just the data pertinent to a race someone is timing?
2) Is there a way to pull the data down from the server and not lose the unqiue ids for each table?
3) If we are NOT able to do #2, how do we get the changes back to the server given that the unique ids of many of the tables have been changed?
Pulling it down part and parcel as we are doing now is a pain but the system works really well once we have done so...except that there are some "new" records (ie: new race participants) that can't be added because their local unique id will potentially be different than the unique id created on the server.
I know I am basically talking about replication but I have not had success with that process in the past.