How can i copy Tables from mssql server from my computer to oder /from my server to oder/. The Data Bases are ready created i must put only the Tables to oder DB. Please can you tell me how?
niki4ko
0
Newbie Poster
Recommended Answers
Jump to PostI am assuming that both databases are on the same SQL Server instance. If you want to transfer a table between databases, try using DTS if you are on SQL 2000. There should be a method for transferring database objects. I won't explain how to use DTS so you will …
Jump to PostWell it really doesn't matter if the two databases are on different servers. All that you need to know is that you must have access to both servers. Then use DTS to copy the table object over.
good luck
All 5 Replies
Geek-Master
niki4ko
0
Newbie Poster
Geek-Master
arjunsasidharan
297
Practically a Posting Shark
niki4ko
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.