SQL server table copy

I've a table TableA in my server. I would like to copy the table to another server.

 Please guide me how to do that.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
 
Cenjoy100Commented:
Follow the steps explained in doc..

 SQL-server-table-copy.doc
0
 
Cenjoy100Commented:
Generate a Create script with data for table.
and the run that script on another server.

Assumption you have similar database on another server.
i.e. all constraints and everything is same on another server.

let me know if you need more info.
0
 
Easwaran ParamasivamAuthor Commented:
I would like to copy with data :)
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.