Can I insert Data one Server to another Server?

Can I insert Data one Server to another Server?

23 Feb 2010 01:02:51
hello, Can I insert Data one Server to another Server? There are two server Test1 and another Test2. In a Test1 Server one database and table like TestTable and and I want to insert data in Test2 Server same Database Name and same Table name. Is is possible or not. Thanks In Advance Jitendra Patel
Jitendra
Junior   Boarder
Posts: 3
From 14-May-2009
You're Points: 112
Bookmark
Re:Can I insert Data one Server to another Server?23 Feb 2010 01:02:51
Hi Yes you can do this in two ways. 1. you can use the DTS Wizard Here full step by step description [url]http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm[/url] 2. you can use the Sql Bulk copy in .NET to transfer data [url]http://www.codeproject.com/KB/database/SqlBulkCopy.aspx[/url] I Hope this is help to achieve this Thank you
RRaveen
Gold  Boarder
Posts: 156
From 03-Jun-2009
You're Points: 1106
Bookmark
^ Scroll to Top