Import an MSSQL database

If you have a .sql dump of your MSSQL database, you can import it onto our MSSQL database servers using any SQL management software.

Import a .sql dump using EMS SQL Manager for SQL Server

Using a SQL script editor you can restore your database SQL script. Instruction on how to import a .sql dump into an MSSQL database using EMS SQL Manager for SQL Server, follow the instructions below.

1. Select Tools
2. New SQL editor item from the menu bar
3. Click Load from File from the middle menu
4. Select the database .sql file from the local computer
5. Click Execute query

This will run your .sql script and restore all of your structure and data into the new database.