:confused: Please help me how to update or copy tables from another computer in MS SQL Server 7, both using Enterprise manager or coding program in VB 6.
Thanks before...
ugie
Printable View
:confused: Please help me how to update or copy tables from another computer in MS SQL Server 7, both using Enterprise manager or coding program in VB 6.
Thanks before...
ugie
Welcome to the forums. :wave:
Are both computers on the same network? Can you easily establish a connection to both?
Data between two sql servers can be transfered using Data Transformation Services (DTS) Manager which was first introduced in MS SQL 7.0.
It's quite easy to use - just follow on screen instructions.