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.
- Select Tools
- New SQL editor item from the menu bar
- Click Load from File from the middle menu
- Select the database .sql file from the local computer
- Click Execute query
This will run your .sql script and restore all of your structure and data into the new database.