Post reply

sharing the database

  • September 19, 2006 at 1:08 pm

    #172758

    We developed a program in VB.NET that reads/writes data into an SQL server database. One of our clients wants to use our software alongside software from a different vendor and share the same database. They have features which we cannot offer and vice versa.

     

    Since the client is already using our program, the database is already structured for our program. Any suggestions on how do I go about sharing the database with this other software vendor?

     

    I was thinking that I can send them our database structure and ask them to save their records in our format directly into the database. Is this the best way to do it? Or can that cause problems?

     

    I’ve seen other programs that allow users to import data in XML and the program inserts the data into the database. Is this a better approach than direct access to the database?

     

    Any ideas or books that discuss this would be appreciated.

     

    ClaudiaM

  • September 19, 2006 at 7:06 pm

    #661394

    < Is this the best way to do it?>

    in theory yes

    in practice: it depends

    --if you combine 2 databases in 1 - how you will support it - push changes, etc. ?

    if you can have side-by-side 2 databases on 1 sql server it maybe let you make right way to use both SW

  • September 19, 2006 at 7:50 pm

    #661402

    I'm not sure I understand what you mean by "if you can have side-by-side 2 databases on 1 sql server it maybe let you make right way to use both SW". How would they share the data?

Viewing 3 posts - 1 through 2 (of 2 total)

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