importing and exporting tables for a local db

[munkeyroot]

Hi Everyone
just want to say to the people who have helped me out in the past ....THANK YOU.

ok so for my next challenge, has anyone attempted this before.
my DB is on our server, so users can login and use.
However my boss is wanting to take it on the road with him. while i am going down the web route for the future, i am looking into my boss having a copy Local DB on his laptop doing some work then when he gets back to site updating the main DB.

i know that their could be an issue with the PK on the tables over lapping or deleting one used etc.?

any thoughts guys?

cheers munk

 

[Minty]

This can be very complicated or pretty simple - it really depends on your data model, and how many referential linked tables you have?

For example - you have a sales order with sales lines. This is linked back to an account number. If your boss added a customer (new account number) and a related sales order, and someone else did the same back at server level you would have a large mess on your hands to attempt to tidy up.

Imagine if both the customers remembered their account number, and placed an order just using that. Who gets the order ?

World of pain.

 

[munkeyroot]

Hey guys
apologies i have only just come back to you all. have been away for a few weeks.

thanks for the information guys, just as i though world of pain!!!

Munk