How to copy Table1 data from client to server database in LAN connection?
mark261511
0
Newbie Poster
Recommended Answers
Jump to PostHi
Is the client database and server database using the same database technology> For example, are they both SQL Server? Does the client have access to the server database?
Does the copy need to be done via code or can it be done via some for of Data Transformation Service …
Jump to PostHi
Do you have access to the database on the LAN from your program? If so, you could add your client table as a linked table into the server database and then do a simple INSERT INTO FROM (SELECT ....) statement that will copy the necessary tables from the linked …
All 6 Replies
mark261511
0
Newbie Poster
djjeavons
113
partis vestri scientia
mark261511
0
Newbie Poster
djjeavons
113
partis vestri scientia
mark261511
0
Newbie Poster
James E
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.