Copy SQL Selected Table Records Between Servers

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

General SQL Server Forums

New to SQL Server Programming

Copy SQL Selected Table Records Between Servers

Author

Topic

piragash
Starting Member

8 Posts

Posted - 2012-04-27 : 22:18:23

Hi,
How to copy the records from selected table between SQL servers using SQL Server 2005. Example From SQL Server A table (Employee) records into SQL Server B Table (Employee). Both table structure are same. How to create sql command to select and insert record with different servers sql authentication.

Server A IP : 192.9.105.1
Database : ABC
Table : Employee
SQL server Authentication ID : admin
Password : admin

Server B IP : 192.9.108.20
Database : Testabc
Table : Employee
SQL server Authentication ID : admin
Password : admin

vinu.vijayan
Posting Yak Master

227 Posts

Posted - 2012-04-28 : 06:47:03

It is a simple ETL job and can be done easily in no time using the Import/Export Wizard in Sql Server 2005. This link will tell you how to:

[url]http://www.databasejournal.com/features/mssql/article.php/3507171/Transferring-Data-from-One-Table-to-Another.htm[/url]

Hope this was helpful.

N 28° 33' 11.93148"
E 77° 14' 33.66384"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-28 : 18:52:19

since its between sql servers itself you can even do it by setting up a linked server connection between the two servers and then using four part naming

http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources