Moving data to another server

[s1shoaib]

Created a query in server A to populate data for columns C,D,E. Now I want to move information for those columns C,D,E in another database in server B. I have already linked the servers.

[lewish95]

Manual Method to Copy Database from one Server to Another
First of all, launch the SQL Server Management Studio from Object Explorer and connect to the Source Server.
Now, right-click on database, select an option Tasks, and then, choose Copy Database option.