Click here to Skip to main content
15,877,966 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hello sir,i wanted to copy tables created in one database to the other database using sql server management studio 2005. can i know the steps to do the same

Perhaps the easiest way is to use SELECT INTO structure.

For example if both databases reside on the same SQL Server, something like:
SELECT Column1, Column2, ....
INTO NewTable
FROM DatabaseName.Owner.TableName

For more info, see INTO Clause[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900