United States

SQL Export and Import

Export

Select a database and export it to be a MDF file for further use, transferring it to another instance or SQL server are both allowed in our product. Our product will also export the transaction log as a LDF file in the process. Following are the detailed steps.

  • Select a database from the database list panel on the left hand.
  • Specify a location where to save exported MDF file.
  • Click Proceed to implement the operation.

Import

Clicking Browse behind data file to import a MDF file, and whether to import transaction log file is optional. If you don't need the actions executed information of the database on original instance, you can just ignore the Browse behind log file.

Besides, you can specify to import to an existed database, which will be overwritten after the operation. Or you can create a new database for importing MDF file.