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?

11 Years
Discussion Span
Last Post by niki4ko

I 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 have to go to Microsoft's website or Books Online.

Another method is to manually create a T-SQL script of the table structure. Run it against the other database and perform an insert command with the values being pulled in by a sub query.

INSERT INTO <databaseB>..<tableA>
    SELECT * FROM <databaseA>..<tableA>

Make sure to replace the examples <...> with the actual DB objects. Also for this script to work, both tables must have the exact table structure.

I woudn't recommend using the SELECT INTO method which will create a table and SQL will guess what the data types are and you will have to manually add the constraints back.


Well 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


If its in the other server or system. You can link the server to your Server name and use the commands that geek master suggested.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.