title: How can I move data from one SQL Server to other?
body: <p>I want to copy all my database to remote database server. I have access to server using SQL server management studio. </p>
  
  <p>How can I do this? I have created script with data of old database and tried to run it on new server but it is taking too much time and returns different errors like duplicate key etc.</p>