Timeline for Sync many client database to one central database
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 7, 2016 at 0:34 | answer | added | Erik | timeline score: 1 | |
| S Jun 22, 2015 at 9:21 | history | edited | Colin 't Hart | CC BY-SA 3.0 |
Corrected the tags to reflect SQL Server edition
|
| S Jun 22, 2015 at 9:21 | history | suggested | DoomerDGR8 |
Corrected the tags to reflect SQL Server edition
|
|
| Jun 22, 2015 at 9:19 | review | Suggested edits | |||
| S Jun 22, 2015 at 9:21 | |||||
| S Jun 22, 2015 at 8:38 | history | suggested | Md Haidar Ali Khan |
edit tagging
|
|
| Jun 22, 2015 at 8:17 | comment | added | Nirav Parmar | Both the Database are SQL Express. | |
| Jun 22, 2015 at 8:15 | review | Suggested edits | |||
| S Jun 22, 2015 at 8:38 | |||||
| Jun 22, 2015 at 7:26 | comment | added | user1822 | Which DBMS are you using? "SQL" is a query language, not a specific DBMS | |
| Jun 22, 2015 at 6:49 | answer | added | DoomerDGR8 | timeline score: 0 | |
| Jun 21, 2015 at 19:51 | history | migrated | from stackoverflow.com (revisions) | ||
| Jun 21, 2015 at 11:27 | comment | added | Nirav Parmar | Yes, it is one way. Admin can only view. | |
| Jun 21, 2015 at 9:02 | comment | added | Enigmativity | This is a one-way sync, right? | |
| Jun 21, 2015 at 8:01 | comment | added | Nirav Parmar | No Central DB is not created. The Admiin application is yet to be created which will be connected to this central DB and Admin could view all the projects. | |
| Jun 21, 2015 at 7:53 | comment | added | DoomerDGR8 | The central DB is also already created and running? | |
| Jun 21, 2015 at 7:10 | comment | added | Nirav Parmar | That is good suggestion but like i said i do not want to change database of the client application because it is already working application and users have already created projects. | |
| Jun 21, 2015 at 6:40 | comment | added | DoomerDGR8 | ProjectId should be GUIDs for a start. I worked on a few projects using Microsoft Sync Framework (msdn.microsoft.com/en-us/library/bb902854(v=sql.110).aspx). But records that required to be synced to central had their Id unique by either GUID, prefixed strings, or composite keys (LocationId+UserId+ProjectId) | |
| Jun 21, 2015 at 6:24 | history | asked | Nirav Parmar | CC BY-SA 3.0 |