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
Posted

Perhaps the easiest way is to use SELECT INTO structure.

For example if both databases reside on the same SQL Server, something like:
SQL
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