CODEWITHSUNDEEP
sql-server-2005sql-server-2008-r2
navbingo
navbingo

Reputation: 223

how to copy table from one server to another in SQL Server?

I am trying to find a way to copy data from one table in SQL Server 2008 to another table in SQL Server 2005. I want to perform this on a daily basis.

Upvotes: 1

Views: 6015

Answers (4)

Berry
Berry

Reputation: 11

If you have a linked server you can write this T-SQL on the targeted server under targeted database:

select * into srctabl from [link server].srcdb.srctable

Upvotes: 1

Jayantha Lal Sirisena
Jayantha Lal Sirisena

Reputation: 21366

You can use Replication service.

SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai

Upvotes: 0

James Culshaw
James Culshaw

Reputation: 1057

You want to look at Sql Server Integration Services (SSIS). This is what is provided with SQL Server to allow you to move data into/out of/around SQL Server and other data formats. It can be scheduled. This is a very simple way of moving data between different servewrs and platforms.

There is a simple wizard available in Management Studio. In the object explorer, right click the required database and choose 'Tasks>Import Data' if you are on the destination server, or 'Tasks>Export Data' if you are on the source server.

James :-)

Upvotes: 2

Gregory Nozik
Gregory Nozik

Reputation: 3374

You created a linked server, than you can retrieve data from linked server and insert to source . Than you create a job that will do it .

You can right click on database and then click import/export (SSIS) . SQL will create a package,that you can view as a script and to run it as job

Upvotes: 2

Related Questions