copying data from one table to an identical one in another database
Posted on 2014-01-29
In SQL Server 2008 (Management Studio) I am able to
"Script Table as > Create To > New query editor window"
and copy-paste-and run it (the code generated) in "myLittleAdmin for SQL" present at Plesk.
Now I need to do "something similar" as far as (just) data is concerned: through SQL Server 2008 Management Studio, I want to copy all data present at a certain table, and paste all the same data in the corresponding (identical-structured) table present at another server, through "myLittleAdmin for SQL" present at Plesk.
I hope I was clear!