Greetings.

So, what is the best of way of doing the following scenario?

We have a program manager system that has many users and each user have a local DB. There is also a central database that gets fed out of each of these local DBs. The program keeps an unique ID based on userID and a millisecond time stamp. (Yes, I know.) So, now, we need to have an unique integer base DB to use that unique ID as TaskID for each project task.

Anyone has any suggestion?

What I am thinking in doing is to go to the main DB and create a new dummy record, which will create a new unique integer id, and then use that ID on local DBs. Later, I could update those unique records with the data based on the local DBs. And so I have this question: can unique id numbers have numbers missing? For example, can a local DB have,

UniqueID, Name, blah1, blah2, blah3
4, john, blah1, blah2, blah3
7, peter, blah1, blah2, blah3
999, juan, blah1, blah2, blah3

etc.

thanks,

josé

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to