How to copy a table with data to one db to another in sql 2005

Home > MSSQL > How to copy a table with data to one db to another in sql 2005

You could use the SQL Server Import & Export Wizard to Transfer data from one table to another table

You could download the sql express edition toolkit from the link below. The DTSWizard comes with the Microsoft SQL Server 2005 Express Edition Toolkit


http://www.microsoft.com/DownLoads/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

D:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I have tried following query for the same purpose and it worked for me
SELECT INTO STAFF FROM Example1.dbo.staff
I have executed the query in the destination database

	index
	create udl file to test sql connection to the sql server
	Error: 18452 SQL Server 2005 "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
	How to copy a table with data to one db to another in sql 2005
	How to insert multiple records to a table using a single Insert query
	How to insert values to multiple tables using a single insert query statement
	How to replace a part of a string of a field using query in MSSQL
	ms sql Add field to table using Alter Table
	ms sql server 2005 express edition
	MSSQL What is the use of COALESCE() function
	System.Data.SqlClient.SqlError The backup set holds a backup of a database other than the existing
	What are the different login modes in sql server
	where is sql server 2005 files stored
	Windows 7 SQL Server 2008 Express R2 Error Unable to connect from remote machine desktop
	sql server error exception system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided
	Restore a database to another database The backup set holds a backup of a database other than the existing
	Stored Procedure Introduction
	How to execute a stored procedure on the sql server query analzer
	Create Stored Procedure Example For beginner
	stored procedure variable orderby
	Stored Procedcure to Update Table
	Stored Procedure Input Variables
	not getting sql server properties on clicking udl file opening as text
	Generic Stored Procedure To Return Get Data From Table With Paging
	Single Stored Procedure Insert Update Delete
	Stored Perocedure ROWCOUNT
	Invalid use of a side effecting operator EXECUTE STRING within a function
	SQL Query MAX Value column
	MSSQL Select GroupBy
	SQL Occurrence of character in a string
	TSQL Functions
	t sql string manipulation STRING BETWEEN TWO STRINGS
	TSQL CHECK IF NULL
	Generic Stored Procedure Insert Update Delete
	Cannot call methods on nvarchar max

Murugan.com
Murugan Andezuthu Dharmaratnam