Juanita
SSCertifiable
Points: 5300
More actions
June 4, 2009 at 8:48 am
#222039
Hello,
Iam new to sql2005, I am trying to see how to copy a sql table from one sql server to another sql server. I knew how to do this using DTS on sql2000 but not sure on sql2005.
thank you !!
Juanita 🙂
Lynn Pettis
SSC Guru
Points: 442467
June 4, 2009 at 8:56 am
#1004695
SSMS has its import/export wizard you can use for this as well.
sql_lock
SSCrazy Eights
Points: 9373
June 4, 2009 at 9:01 am
#1004698
As Lynn as already posted, use the import/exp wizard.
Below is a good article with print screens.
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm
June 4, 2009 at 9:11 am
#1004711
Thank yall so much !!!
Exactly what I needed and worked like a charm !!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply