Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

Restoring a MSSQL database from a .sql file using EMS Sql Manager Lite

How do I restore an MSSQL database from a .sql file?
If you don't have a SQL management program, go to http://sqlmanager.net/en/products/studio/mssql
to download the freeware version and install to your local computer.
 
  1. Start EMS Sql Manager.

  2. If this is your first time working with this database in Sql Manager, you
    first need to register the database:

    • Select Database--> Register Database from Main Menu

    • Enter Server Name (ie, mssql#.hspheredns.com)

    • Select Sql Server Authentication

    • Enter username and password

    • Click Next

    • Enter database name and alias

    • Click Finish


      •  

  3. Import your .sql file:

    • Select Database--> Connect to Database from Main Menu

    • In the Destination box, select your database from the second dropdown

    • Select Tools--> SQL Script from Main Menu

    • Click "Open Script" in the General box and navigate to your .sql
      file, then click Open

    • Click "Execute script" in the General box