|
|
SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers
Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc.
If you want to transfer all the objects from one database to another, open Sql Server Management Studio > Right click on your database > All Tasks > Generate SQL Scripts. Then run these scripts against the new database.
Transfer both schema and data
To copy both data and schema, use the Microsoft SQL Server Database Publishing Wizard 1.1. This tool works for both SQL 2000 and SQL 2005 and generates a single SQL script file which can be used to recreate a database (both schema and data).
Did you like this post?
|
|
||
|
|
|
|
|
subscribe via rss |
|
subscribe via e-mail |
|
print this post |
|
follow me on twitter |
comments
24 Responses to "Copy a table from one database to another in SQL Server 2005"Thank you! I was searching the net to copy a table and found ur blog.
I am still looking for pure copy table without using SQL Statement (SQLServer SMO is prefered) but I think I am going to use your tips if none I can find...
Nice blog :)
___________
Daniel - averagecoder.net
averagecoder: The solution you choose also depends on the size of your table. Using the scripts 'may' not feasible if your table contains a million rows.
thanks for the help :-)
Thanks a lot! Nice blog!
you're a star!
your a retard lmao
Thanks for this. But does this work with large tables?
Averagecoder - have you tried Import/Export as a solution to copying tables? Unfortunately, this does not work with tables with 1000s of rows.
Thanks for the Help!
Thanx it really saved my time and effort
it creates a new table. i want to copy just data from one table to another
Thanks for the post.
thank u
thanks buddy
Thankyou so much buddy, I tried in many ways to get this done, but finally your solution helped me.
Nice blog.
Thank you for sharing knowledge and helping others with it.
Amir
From db2, type this in your query analyzer:
INSERT INTO copytable SELECT * FROM db1.dbo.origtable
...........................Thankyou
Thanks, it works!
Thank you!
- venky
Thanks ! ! ! ! !
Thank you! Perfect
Thanks, dude. Still helpful.
insert into Suprotim_Agarwal_comments values('Thanks a lot bro');
Hi,
http://hightechpost.blogspot.com/2011/10/copying-table-in-sql-server-2005.html
check it in simple way for:
1)Copy table from same Database:
2)Copy table from another Database:
3)Copy few columns into the destination table:
regards
hightechpost
Post a Comment