SQL Server Performance Forum – Threads Archive
Transfering table data from one server to another
I have to transfer few tables from one server to another server.As in sql 2000 any import export tool exist in 2005 ? Thanks DBA
Yes you can use Import/Export wizard, from SSMS –> database –> Table –> right-click to get this option.http://www.databasejournal.com/features/mssql/article.php/3580216 fyi.
You can still use DTS to accomplish or use SSIS in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.