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

    • Related Articles

    • Extract or backup a MSSQL database to a .sql file using EMS Sql Manager Lite

      How do I extract or restore an MSSQL database to 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.   Start EMS Sql ...

    • Restoring MSSQL via MS SQL Studio - VPS/Cloud/Dedicated only

      To restore a MSSQL database to your VPS or dedicated server, you would do the following steps: 1) Login to MS SQL Studio via remote desktop -- you will want to use an admin login and if you do not have this please contact us. 2) Right click the ...

    • Import Database into Plesk

      How to import a MSSQL database - Windows Shared This process cannot be done via the MSSQL client. Instead, it must be completed inside of the control panel using these steps: Create a blank MSSQL database. Restore the Blank Database With the Database ...

    • MSSQL Admin Tools

      I would like to manage my MSSQL database. How can I do this? On some of our MSSQL servers we have installed a tool called MyLittleAdmin. This web application allows you to edit your database, back it up and restore it from a backup (MSSQL 2005 & 2008 ...

    • MSAccess to MSSQL

      I would recommend that you import your MS-Access database into a sole MSSQL database (as MS-Access is now considered obsolete anyway) you can use any of the following ways; ...