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.
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.
