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
    •