title: How to migrate a database from SQL Server 2005 to 2008 as is?
body: <p>I want to migrate a database completely or partially. Right now, I will do a complete database. Partial will be posted as a separate question.</p>
  
  <p>Strategies I am considering:</p>
  
  <ol>
  <li>copy database wizard</li>
  <li>convert 2005 database to script. Run script on 2008</li>
  <li>simple SQL query</li>
  </ol>
  
  <p>My question - I want to use method 2. Is it even possible to do this? If yes, how to do it? Any limitations/risks ?</p>
  
  <p>NOTE - The source server is a SQL Server 2005 database with one IP. Destination is a SQL Server 2008 instance with another IP.</p>
  
  <p>I don't know if you need to be sysadmin to do this. I am not even sure if I am sysadmin. If yes, then how to check if I am a sysadmin ?</p>