Link to home
Start Free TrialLog in
Avatar of Easwaran Paramasivam
Easwaran ParamasivamFlag for India

asked on

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.
Avatar of Cenjoy100
Cenjoy100
Flag of India image

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.
Avatar of Easwaran Paramasivam

ASKER

I would like to copy with data :)
ASKER CERTIFIED SOLUTION
Avatar of Cenjoy100
Cenjoy100
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks.