ManicCW
Well-known member
Transfer data client - server
I have one big problem. I have application than uses msde database. Application is installed on several client computers that have no connection to main server. Now I need to transfer data from client to server using sql scripts or something.
How do I manage keys??? Because there are some related tables so if I insert data the keys wont match because two different clients can have same data ID (for example CustomerID).
Is there a solution???
I have one big problem. I have application than uses msde database. Application is installed on several client computers that have no connection to main server. Now I need to transfer data from client to server using sql scripts or something.
How do I manage keys??? Because there are some related tables so if I insert data the keys wont match because two different clients can have same data ID (for example CustomerID).
Is there a solution???
Last edited: