Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Copy Table Datas from One server to another server

Author  Topic 

Kalaiselvan
Posting Yak Master

112 Posts

Posted - 2011-01-26 : 14:28:47
Hi,

ServerA 192.168.1.1 Sql Server 2005
ServerB 220.230.245.1 Sql Server 2008

Database: FinanceReport (ServerA and ServerB)

Please help me how to copy ServerB Table datas to ServerA table which Database name and Table name are same.

Note: Tables will have 2Crores records. How to make it possible from transferring one table records to another table where the Servers are different but Database is same.

Regards,
Kalaiselvan R
Love Yourself First....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-26 : 14:53:00
There are lots of methods:

1. bcp.exe
2. DTS/SSIS
3. OPENQUERY
4. Linked server
5. bcp.exe out/BULK INSERT (in)
6. Replication

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -