Migrating Databases

To migrate a database:

  1. Right click on the database on the source server
  2. Backup
  3. Save the file as *.sql
  4. Create a new database on the target server
  5. Right click the new database and select restore
  6. Choose the *.sql file you made to restore from