Click here to Skip to main content
15,895,799 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Thin Client Compiler ? Pin
W Balboos, GHB20-Jun-12 2:11
W Balboos, GHB20-Jun-12 2:11 
GeneralRe: Thin Client Compiler ? Pin
Eddy Vluggen20-Jun-12 2:30
professionalEddy Vluggen20-Jun-12 2:30 
AnswerRe: Thin Client Compiler ? Pin
jschell19-Jun-12 13:21
jschell19-Jun-12 13:21 
GeneralRe: Thin Client Compiler ? Pin
W Balboos, GHB20-Jun-12 1:46
W Balboos, GHB20-Jun-12 1:46 
AnswerRe: Thin Client Compiler ? Pin
Bernhard Hiller19-Jun-12 20:41
Bernhard Hiller19-Jun-12 20:41 
GeneralRe: Thin Client Compiler ? Pin
W Balboos, GHB20-Jun-12 1:58
W Balboos, GHB20-Jun-12 1:58 
Questionprobleme schema object rational rose Pin
ahmadiss16-Jun-12 5:53
ahmadiss16-Jun-12 5:53 
QuestionWhat's The Right Way To Do This? Pin
Kevin Marois15-Jun-12 7:26
professionalKevin Marois15-Jun-12 7:26 
I'm building an retail appliction where the software will be installed locally on the client. There will be a local copy of the database, and the software will do CRUD operations on it.

Then, each day the software will send inserts/updates/deletes to the server. On the server the database is identical to the local DB.

The reason for this design is that if the user cannot connect to the server, the software has to still be able to run. The customer cannot be stopped from using the software in their store because they cannot connect to the server.

To facilitate this I'm going to use composite primary keys. The first part of the key is the CustomerId, and the second is the Id of that table. So, for an Order row the key would be CustomerId + OrderId. This way, when the data is pushed to the server I will have unique keys across all customers.

The question is this... Assume a new customer downloads and installs the software. How do I get the CustomerId? I'm guessing that during setup I would connect to the server and get the next available CustomerId, and to do that I would have to store the CustomerId to the server's table right then & there. But again, what if they can't connect?

Anyone have a better idea? Any problems with this design?

Thanks
If it's not broken, fix it until it is

AnswerRe: What's The Right Way To Do This? Pin
Pete O'Hanlon15-Jun-12 7:58
mvePete O'Hanlon15-Jun-12 7:58 
GeneralRe: What's The Right Way To Do This? Pin
Kevin Marois15-Jun-12 8:00
professionalKevin Marois15-Jun-12 8:00 
GeneralRe: What's The Right Way To Do This? Pin
Eddy Vluggen17-Jun-12 8:36
professionalEddy Vluggen17-Jun-12 8:36 
GeneralRe: What's The Right Way To Do This? Pin
jschell17-Jun-12 13:08
jschell17-Jun-12 13:08 
AnswerRe: What's The Right Way To Do This? Pin
Eddy Vluggen17-Jun-12 8:34
professionalEddy Vluggen17-Jun-12 8:34 
AnswerRe: What's The Right Way To Do This? Pin
Luc Pattyn17-Jun-12 9:21
sitebuilderLuc Pattyn17-Jun-12 9:21 
AnswerRe: What's The Right Way To Do This? Pin
Mycroft Holmes17-Jun-12 14:41
professionalMycroft Holmes17-Jun-12 14:41 
GeneralRe: What's The Right Way To Do This? Pin
Kevin Marois22-Jun-12 10:56
professionalKevin Marois22-Jun-12 10:56 
GeneralRe: What's The Right Way To Do This? Pin
Mycroft Holmes22-Jun-12 13:10
professionalMycroft Holmes22-Jun-12 13:10 
GeneralRe: What's The Right Way To Do This? Pin
Kevin Marois22-Jun-12 14:01
professionalKevin Marois22-Jun-12 14:01 
Questioncolor mixing riddle Pin
Kobi_Z13-Jun-12 21:52
Kobi_Z13-Jun-12 21:52 
AnswerRe: color mixing riddle Pin
Bernhard Hiller13-Jun-12 22:18
Bernhard Hiller13-Jun-12 22:18 
GeneralRe: color mixing riddle Pin
Kobi_Z14-Jun-12 4:52
Kobi_Z14-Jun-12 4:52 
GeneralRe: color mixing riddle Pin
Philippe Mori17-Jun-12 2:50
Philippe Mori17-Jun-12 2:50 
AnswerRe: color mixing riddle Pin
Richard MacCutchan14-Jun-12 5:19
mveRichard MacCutchan14-Jun-12 5:19 
GeneralRe: color mixing riddle Pin
Kobi_Z14-Jun-12 7:16
Kobi_Z14-Jun-12 7:16 
GeneralRe: color mixing riddle Pin
Richard MacCutchan14-Jun-12 7:30
mveRichard MacCutchan14-Jun-12 7:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.