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

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.
  1.  
  2. Start EMS Sql Manager.
  3.  
  4. If this is your first time working with this database in Sql Manager, you     first need to register the database:
  5.  
    •    
    • 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
    •  
  6. Backup your data/export .sql file:
  7.  
    •    
    • Select Database--> Connect to Database from Main Menu
    •    
    • In the Destination box, select your database from the second dropdown
    •    
    • Select Tools--> Extract Database from Main Menu
    •    
    • Select your database from the dropdown menu
    •    
    • Click Next
    •    
    • Select "Save to file"
    •    
    • Select the File name and File charset
    •    
    • Select the components you'd like to extract:      
      •        
      • Extract database objects
      •        
      • Extract data
      •      
         
    •    
    • Click Next
    •    
    • Select script options and data options, then click Next
    •    
    • Click finish
    •  

    • Related Articles

    • 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.   Start EMS Sql Manager. If ...

    • 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 ...

    • 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 ...

    • File Manager Cpanel / Fixing 403 correcting permissions.

      Learn how to troubleshoot WordPress 403 Forbidden error messages. We show you how to check for a corrupt .htaccess file. Diagnose faulty WordPress Plugins and checking for correct WordPress file permissions. Problem When you attempt to view your ...

    • 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 ...