Post reply

how can i manage the problem for creating EmployeeId which work as offline and online

  • June 1, 2010 at 1:39 am

    #94914

    Hi all

    I am describing my problems bellow

    My application is running from offline system via desktop aplication and

    as online via web application in which two are using same database in one server.

    I am using a table called Employee ,it contains EmployeeId as Primary Key

    The problem is if i will create a new entry, EmployeeId from desktop application and web application

    should be same in some way...

    So how can i handle this problem......

    Could any please provide me good approach like replication , ...

  • June 1, 2010 at 2:31 am

    #1174678

    Looks like a good place for Merge Replication.

    http://technet.microsoft.com/en-us/library/ms151329.aspx

    -- Gianluca Sartori

  • June 1, 2010 at 4:33 am

    #1174702

    Do you want same EMployeeID from desktop Application and Web Application? WHY?

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • June 1, 2010 at 5:04 am

    #1174709

    what my need is

    some users are working from palm with offline and

    others are woking as online...i need same DB with same server for both...

    i am planning to use synchronisation...(i am not aware of that)

    But my problem is if a new employee will create in both side..

    and if I use sync, EmployeeId will be ambiguos..

    Any idea for avoiding this ......

  • June 1, 2010 at 5:31 am

    #1174719

    OK. You must be using SQL Server compact edition on PDA device.

    You would need to design a complete solution for that.

    Try this link...

    http://msdn.microsoft.com/en-us/library/ms171850(SQL.100).aspx

    And

    http://www.devbuzz.com/Articles/zinc_sql_merge_replication_pg1.aspx

    The tip fro your question is that do not initialize ID in tblEmployee on PDA. Use Another table like tblEmployee_PDA on PDA device, sync it with server having tblEMployee_PDA and then get data from Server's tblEmployee_PDA to tblEMployee on DB Server. After delete from tblEMployee_PDA on PDA. Sync tblEMployee Again.

    Alot of work. I used this strategy when I synchronized the inventory requisition and issuance data data from PDA to DB Server.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • June 1, 2010 at 6:57 am

    #1174748

    Thanks..Can you give me some more details in it

  • June 1, 2010 at 7:00 am

    #1174749

    shameej_thbs (6/1/2010)

    Thanks..Can you give me some more details in it

    Like what?

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • June 1, 2010 at 11:17 pm

    #1175098

    Actually i don't know about sync ..

    Can you just tell me how can we do sync ...

    Also one more doubt, if we push datas from tblEMployee_PDA to tblEmployee , how can we manage the Id problem in both..

    eg:

    if one user in PDA entered an entry(to tblEMployee_PDA ) so..Suppose for Id(ie PK here) is 200

    and another user in Online will enter an entry(to tblEmployee ) ,then there also Id(ie PK here) is 200

    ..How can i manage this problem..?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply