title: Migrate to Amazon SQL Server RDS
body: <p>I have been attempting to move from a regular SQL Server on a Win2008 Server to the SQL Server on Amazon AWS RDS. </p>
  
  <p>I thought an simple backup and restore would work. Though AWS RDS doesn't seem to have access to a file system so the sql scripts all seem to need a local file system on the source and destination server. I attempted a script following </p>
  
  <pre><code>exec sp_addlinkedserver @server='test.xxxx.us-east-1.rds.amazonaws.com'
  
  -- Verify that the servers were linked (lists linked servers)
  exec sp_linkedservers
  
  EXEC ('RESTORE DATABASE [orchard] FROM DISK = ''C:\Temp\orchard.bak'' WITH FILE = 1,  NOUNLOAD, STATS = 10')
  AT [test.xxxx.us-east-1.rds.amazonaws.com]
  </code></pre>
  
  <p>Any Suggestions would be helpful.</p>