Migrating Databases
To migrate a database:
- Right click on the database on the source server
- Backup
- Save the file as *.sql
- Create a new database on the target server
- Right click the new database and select
restore
- Choose the *.sql file you made to restore from