To Copy a table from one database to another or within the Database in SQL Server 2005

jagadeep's profileWelcome to jagadeep's s...PhotosBlogListsMore

Tools

Help

< Previous Next >

February 10

To Copy a table from one database to another or within the Database in SQL Server 2005

>>If you have a table in a database and you would like to copy the table to another database, then use this query

Select * into AdventureWorks.dbo.Employees_New from Nothwind.dbo.Employees

Executing the above query will copy your table to a new database.
Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys.

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.

To 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).

12:59 PM | Blog it | SQL SERVER 2005

Comments

To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in

Don't have a Windows Live ID? Sign up

Trackbacks

The trackback URL for this entry is:

http://jagadeeps.spaces.live.com/blog/cns!D42C7F8521DB01F!499.trak

Weblogs that reference this entry

None